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 [mailto:[EMAIL PROTECTED] > Sent: Friday, December 12, 2003 2:04 PM > To: [EMAIL PROTECTED] > Subject: sub select equivalent > > > 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? > > Thanks. > Dean Hoover > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
