sql syntax error

Post Author: nik

CA Forum: Data Connectivity and SQL

Hi. Probably I'm missing something important but... I cannot save a sql query without getting an error:I just want to create a query like SELECT FROM Normally I write: SELECT 'field' FROM 'table' I've noticed that in CR fields are imported in this way: "table"."field" So I tried with: SELECT "table"."field" FROM "table"I tried: SELECT "field" FROM "table"I tried: SELECT field FROM tableand other... The message error gives an incorrect syntax near SELECT Someone could help me? Thank you