David,

Once again, thanks (guess I was missing the table keyword).
Both examples worked perfectly.
Didn't understand the 1=2, unless that was just a bogus clause to get a 0 record result (I assumed that a 0 result would not create anything).

As in past occasions, thanks againg for your guidance and effort!


>Ashley,
>
>>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.
>
>Maybe if you post the SQL we can help you find the error.
>
>This ought to do what you want:
>
>

select distinct * ;
>   from TheTable ;
>   into table TheDistinctTable

>
>>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).
>
>

select * ;
>   from TheTable ;
>   into table TheTableStructure ;
>   where 1=2