>Help!
>This is probably simple and obvious, but I get syntax errors trying to formulate the SQL statement.
>I would like to extract only the records from a table that are DISTINCT in every field into another table.

select distinct * from table1 into table2

>Another one is: How do I query just 1 record using SQL? I just want to create a table which echoes the structure of the database being queried (Yes, I could zap the result, but that sems the ugly way to do it).
>
>TIA

select table1
copy structure to table2 with cdx