Unions

This is the first UNION SQL code I have written:

SELECT Field1, Field2, Field3 FROM Table1
UNION SELECT Field1, Field2, Field3 FROM MasterTOStatus;

And it work!

SQL Documentation

Microsoft Transcat-SQL Reference online document.

SQL 2005 Server

• Elements of Transact-SQL
• Query Fundamentals
• Using SQL Server Tutorials
• Query Fundamentals

SQL Access 2000

• Fundamental Microsoft Jet SQL
• Intermediate Microsoft Jet SQL
• Advanced Microsoft Jet SQL

IBM Informix

• Syntax
• Reference
• Tutorial

SQL Comments

The standard SQL comment is '--'. This works in SQL Server. However, Access doesn't permit comments.