So you have several table for the teachers. make the join and instead of "using" use "on so: select disctinct * from table1 left join table2 on table1.for_key12=table2.for_key21 left join table3 on table2.for_key23=table3.for_key32 .... Example : select disctinct * from teacher1 left join teacher2 on teacher1.shool=teacher2.kindga;
Regards, Andrey ----- Original Message ----- From: "Vasoczki Ferenc" <[EMAIL PROTECTED]> To: "'Andrey Hristov'" <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 11:47 AM Subject: RE: [PHP] Soring an array hm, maybe, just i don't understand this join exactly... as i said i have 5 tables. every table have a primary key. The 1-3 this called "school", in the 4-5 this called: "kindergarten". And i want to get out, all the different month, and year. like: Teacher table: shool | month |year | 25485 04 2001 etc... Teacher table: kindga| month |year | 25485 04 2001 25485 03 2002 etc... imagine the rest of.. and i need only 2 items: 042001 032002 Vaso -----Original Message----- From: Andrey Hristov [mailto:[EMAIL PROTECTED]] Sent: 2002. április 9. 10:39 To: Vasoczki Ferenc Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Soring an array select distinct member_id from mails_sent left join member_info using(member_id) left join stats_done using(member_id)... so select distinct number_number from table1 left join table2 using(you_foreign_key) left join table3 using(your_foreign_key2) .... your_foreign_key* is a field common to table(x) and table(x+1) HTH Regards, Andrey Hristov ----- Original Message ----- From: "Vasoczki Ferenc" <[EMAIL PROTECTED]> To: "Php Mailing List (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 11:26 AM Subject: [PHP] Soring an array > Hi! > > I am new on this list, so i welcome everybody! > /sorry if my english is not too good/ > > My problem is: > I want to sort an array. > I found the array_multisort funciton in the help, but that is for > multidimensional arrays, or 2 or more arrays. > > What i need exactly. > > I have 5 MySQL tables, and i want to collect some informations from all > theese tables, and then get out only the different items. > Like: 1st table: 1,2,3 2nd: 2,4,3 3rd: 5,1,5 > > I need an array, what will include 1,2,3,4,5 > > So i thought, i collect all the numbers in 1 array, then sort it, and then > get out the duplicat items. > > Any suggestion ? > > Thx > > Vaso > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
