Solved: SELECT query

[philfer]

Hello,

In a DB I am working on in a VBA module they ahve the following SQL :-

SELECT CompanyName FROM tblCustomers WHERE Flase;

Dont they need to have something after WHERE e.g. a field name. How will the DB know which field to check against False?

Any help would be appreciated

Thanks
Phil

[RolfJ]

Yes, you are correct in assuming that this is an incomplete SELECT statement. You might want to consult http://www.w3schools.com/Sql/sql_where.asp for the proper syntax.

[austenr]

Looks like you need a field name and operator after WHERE and before False