subject:"sub select equivalent"

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? http://www.

RE: sub select equivalent

2003-12-12 Thread Dan Greene

> 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 f

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