Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

SELECT statement. SQL Server 2000 introduces SQL collations, a large collection of named collation types that specify different combinations of character sets and sort orders.