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]
