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