SELECT COUNT(*) AS thecount FROM table1 LEFT JOIN tabel2 ON (table1.col1 =
table2.col2) GROUP BY table1.col3 ORDER BY thecount;
It might give you some hints...
Best regards,
Peter Lauri
www.dwsasia.com - company web site
www.lauri.se - personal web site
www.carbonfree.org.uk - become Carbon Free
> -Message d'origine-
> De : Skip Evans [mailto:[EMAIL PROTECTED]
> Envoyé : mercredi 31 janvier 2007 17:26
> À : PHP-General
> Objet : [PHP] Need desperate help with query
>
> Okay, so SQL questions shouldn't come to the list,
You are aware of that too eh?
So why mail here?
> but I a
2 matches
Mail list logo