On 20 Mar 2006, at 16:34, Ian M. Jones wrote:
Here's a super stripped down db and test sql scripts that still
show the problem:
http://www.ianmjones.net/wp-content/stuff/NoOuter.zip
Thanks to [EMAIL PROTECTED] the solution has been found.
I've updated the zip file with an extra "SOLVED.sql" file that shows
the solution (using "and" in the join rather than separate "where").
It's a shame that I can't use a where clause, but it works, so I'm
not going to complain.
Regards,
--
Ian M. Jones
___________________________________
IMiJ Software
http://www.imijsoft.com
http://www.ianmjones.net (blog)
