Bob Lockie wrote:
On 06/21/2004 04:26 PM [EMAIL PROTECTED] spoke:
I don't understand. You want every other record except .what?
By flipping the equality the way you did, you should see all of the
records where a.id = b.id (regardless of what the b.type value is) where
a.type was not 'X' which
On 06/21/2004 05:02 PM Brent Baisley spoke:
The opposite of the query would be a.type!='X' and there is no related
record in table b. Not sure if that is what you what
It isn't what I want because there could be other a.type other than 'X'.
Oops, that should be b.type
I need to return the a record
On 06/21/2004 04:26 PM [EMAIL PROTECTED] spoke:
I don't understand. You want every other record except .what?
By flipping the equality the way you did, you should see all of the records
where a.id = b.id (regardless of what the b.type value is) where a.type was
not 'X' which is one reasonably v
The opposite of the query would be a.type!='X' and there is no related
record in table b. Not sure if that is what you what, but this is what
the query would look like:
select name from a left join b on a.id=b.id where b.id is null and
a.type!='X'
On Jun 21, 2004, at 4:04 PM, Bob Lockie wrote:
I don't understand. You want every other record except .what?
By flipping the equality the way you did, you should see all of the records
where a.id = b.id (regardless of what the b.type value is) where a.type was
not 'X' which is one reasonably valid solution to the statement "all of the
row
