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

As we saw in the last article, the SQL SELECT statement has the widest variety of query options, which are used to control the way data is returned. These options come in the form of clauses ...