Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL 101 - 2 questions
Message
From
02/07/2002 21:27:35
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL 101 - 2 questions
Miscellaneous
Thread ID:
00674789
Message ID:
00674789
Views:
66
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.
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
Next
Reply
Map
View

Click here to load this message in the networking platform