-
SQL Query to create new table
I run a local quiz league and have a table with the following fields: -
ID, Team Name, Division, PLayed and Points
Using an SQL query I would like to create a new table which will take all teams where Division = 1 and ensure every team is in the new table next to every other team (once only!). Two further fields also need to be created called 'Date' and 'Venue', however these fields will be left empty for a user to enter the information at a later date.
Any help with this would be greatly appreciated.
If you would like to see the database, email me on marklord82@hotmail.com
Cheers,
Mark
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|