Unable to Solve NOT IN Problem ....

[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 me know the equilient of the above query at the earlist
 
Thanking you 

with regards
KARTHIK