Hi Nadia,
Thanks for the reply..
>>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
I tried this:
use d:\mydbf
select distinct * from mydbf into c:\temp
and got "Syntax error"
>
>>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
Sorry Nadia, I should have made myself clear - The source was an ODBC connection to an Access database.
Regards