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/AJ4tVDPmziZsSmTze2KpAQge6AQb5wCePN7O >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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
