List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 30 1999 5:20am
Subject:Re: AHH! ORDER BY on a left joined table!
View as plain text  
On Wed, 1999-09-29 18:13:20 -0500, Mr. Anthony R.J. Ball wrote:
>   I have ver 3.22.25, with a query that contains a left join... and
> whenever I try to use one of the values from it it won't return a
> row unless it has values in it... effectively nullifying my left
> join... is there any way around this?

Combining LEFT JOIN and ORDER BY the way you describe it _should_ work,
and it does for me with MySQL V3.22.19b (just tested).

Please, show always what you've tried and what results you got.  Then
it's probably much easier to help you ...

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
AHH! ORDER BY on a left joined table!Mr. Anthony R.J. Ball30 Sep
  • Re: AHH! ORDER BY on a left joined table!Martin Ramsch30 Sep