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