>feels strange to JOIN tables and
>choose rows where the join value is NULL (left outer join) :)
It's standard SQL and has a name, "exclusion join". Not a bit more
"strange" than counting wot's missing.
Peter Lauri wrote:
4.0.27, so that is probably the reason. Any other way then with a sub query?
I solved it with my "stupid" solution, feels strange to JOIN tables and
choose rows where the join value is NULL (left outer join) :)
From: Chris White [mailto:firstname.lastname@example.org]
Sent: Thursday, July 27, 2006 6:05 AM
Subject: Re: JOIN table where not in other table
On Wednesday 26 July 2006 11:00 am, Peter Lauri wrote:
The query in full was exactly as you wrote it (but without the typo) :)
Alright, yes, what is your version of MySQL? I'm in the 5.0.22 series here
and that works just fine.