List:General Discussion« Previous MessageNext Message »
From:Becoming Digital Date:May 28 2003 9:21pm
Subject:Re: problem with subquery
View as plain text  
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" <gerald_clark@stripped>
Cc: <mysql@stripped>
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/mysql?unsub=1




Thread
problem with subqueryHassan Farha28 May
  • Re: problem with subqueryJames Moe28 May
    • Re: problem with subquerygerald_clark28 May
    • Re: problem with subqueryBecoming Digital28 May
      • Re: problem with subqueryJohn Hicks30 May