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
