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