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

What’s your average success rate of getting a SQL statement right on the first try? In best case, you botched a simple statement without side effects and just have to try again with correct ...

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.

Maybe this is a strange question, but is there a way to add a single row (or several) to the return set of a SELECT statement?Example:I want to populate a drop down list with SELECT EmpID ...