SQL Select Issue

[Glenn Hancock]

I am trying to select all records that exist in table1 that do not exist in table 2. As an example: I am trying to do the following

select field1 from table1 where field1 not in (select field1 from table2 where field1=table1.field1)

This works on one db system but when I try it on mysql it fails but doesn't give me anything specific that failed, just message to check help file. But I can't find anything in docs on performing a not in function...

Any help?

Thanks,

glenn