Skip to Content
0
Former Member
Sep 07, 2007 at 04:54 PM

sql syntax error

26 Views

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