subject:"sub select equivalent"

sub select equivalent

2003-12-12 Thread Dean A. Hoover

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

RE: sub select equivalent

2003-12-12 Thread Dan Greene

[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

Re: sub select equivalent

2003-12-12 Thread Paul DuBois

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?