On 21 Mar 2006, at 18:11, Ed Porter wrote:
Hi Ian,
You nee to use a Full Outer Join. I don't know if SQLite has this
function.
Nah, definitely only wanted a left outer, didn't want the results
multiplied up or anything, just wanted every Category and any Cases
if matching the criteria.
It was solved by moving the where clause up into an AND on the join,
seems that the where clause choking the result set from the outer
join. Never seen this before, but then again I've generally used "old
style" syntax joins (in the where clause), not ANSI, so I'm a bit new
to how the where clause can effect the results of an ANSI join. But
I'm learning!
Thanks for your response though Ed, much appreciated.
Regards,
--
Ian M. Jones
___________________________________
IMiJ Software
http://www.imijsoft.com
http://www.ianmjones.net (blog)
