error 1064???

[Giancarlo]

SELECT *
FROM CIP$Import
WHERE NOT EXISTS (SELECT * FROM categories_description WHERE categories_description.categories_name=CIP$Import. v_categories_name_1);

I am using the above query which gives me error 1064, can someone please help me -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[rian]

Try wrapping your table names with backticks, e.g. `CIPImport`. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --