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