> WHERE TAB2_ID 2 > is the problem. > Do you want = or <> or what?
Except that if you check the original post you'll see: SELECT * FROM TAB1 WHERE TAB1_ID IN (SELECT TAB2_ID FROM TAB2 WHERE TAB2_ID > 2) The ">" was at a line break and got swallowed up in the replies with the >>s at the beginning of the quotes. So the original post stands unanswered :( --John On Wednesday 28 May 2003 05:21 pm, Becoming Digital wrote: > Well noticed, Gerald. I glossed over that bcs the entire > query was in caps. I find it best to capitalize only SQL > reserved words, which might be a good suggestion to the > original poster. > > Edward Dudlik > Becoming Digital > www.becomingdigital.com > > > ----- Original Message ----- > From: "gerald_clark" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Wednesday, 28 May, 2003 16:49 > Subject: Re: problem with subquery > > > WHERE TAB2_ID 2 > is the problem. > Do you want = or <> or what? > Also your version of MySQL must support sub selects. > > James Moe wrote: > >-----BEGIN PGP SIGNED MESSAGE----- > >Hash: SHA1 > > > >On Wed, 28 May 2003 15:18:16 -0400, Hassan Farha wrote: > >>SELECT * FROM TAB1 WHERE TAB1_ID IN (SELECT TAB2_ID > >> FROM TAB2 WHERE TAB2_ID > >> > >>>2) > >> > >>I know I this select is very simple, ... > > > > So what's the problem? > > > > > >- -- > >jimoe at sohnen-moe dot com > >pgp/gpg public key: http://www.keyserver.net/en/ > >-----BEGIN PGP SIGNATURE----- > >Version: PGPfreeware 5.0 OS/2 for non-commercial use > >Comment: PGP 5.0 for OS/2 > >Charset: cp850 > > > >wj8DBQE+1RJ4sxxMki0foKoRAkk/AJ4tVDPmziZsSmTze2KpAQge6AQb > >5wCePN7O c8oEF5CeBo915LfDeHj0lLo= > >=Xb4Z > >-----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
