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