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 ...
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