I wonder how people use RDBMS w/o ever
reading manuals. Do they get paid for their
work?
----- Original Message -----
From: "Sheshadri YS" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 26, 2001 6:57 PM
Subject: Unable to Solve NOT IN Problem ....
Respected Sir,
We are facing problem in running this below given Query in mysql 3.23
SELECT COL1 FROM A WHERE COL1 NOT IN (SELECT COL2 FROM B WHERE
COL3=001)
Table A (col1,col2 is of varchar )
Table B (col1,col2 is of varchar, col3 = numeric )
ALSO Table1.col1 == Table2.col1
SO Please let me know the equilient of the above query at the earlist
Thanking you
with regards
KARTHIK
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
