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

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 Respected Sir, We are facing