Re: Unable to Solve NOT IN Problem ....

2001-04-26 Thread Artem Koutchine
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

Unable to Solve NOT IN Problem ....

2001-04-26 Thread Sheshadri YS
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