Oliver_Reid

Whats wrong with this ODBC import query?

Discussion created by Oliver_Reid on Oct 4, 2012
Latest reply on Oct 4, 2012 by beverly

Query

 

SELECT "zips"."a_rec_id", "zips"."aa_county_id", "zips"."b_city", "zips"."County Name", "zips"."County Population", "zips"."State Abbreviation", "zips"."State Name", "zips"."Zip Code"

FROM "zips"

WHERE "zips"."State Abbreviation" IN (CT,NY, NJ)

 

 

Error

 

 

 

ODBC Error: [FileMaker][FileMaker] FQL0007/(1:235): The column named "CT" does not exist in any table in the column reference's scope.

 

 

What is the correct typography for using IN with a literal list?

Outcomes