At 14:03 -0500 12/12/03, Dean A. Hoover wrote:
I am using version 3.23.58 and need to do
the following:
select * from a where id not in (select tbl_id from b where tbl="a");
Given that my version does not support sub selects, how
can I re-write the statement to get the desired results?
http://www.
left joins are your key
select * from a
left join b on id = tbl_id and b.tbl = "a"
where b.tbl_id is null
(not 100% sure on my syntax, but note the join, and the limitation on 'left' result
set is specified within the left join clause)
> -Original Message-
> From: Dean A. Hoover [m
