Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

SELECT options refine results As we saw in the last article, the SQL SELECT statement ... free to use ORDER BY with any select statement that might return multiple rows. You can also use it ...

If you're using ADO.NET, you can combine multiple Select statements in your Command object's CommandText ... procedures when you need some control logic mixed in with your SQL statements.