Due to popular demand, we’re back with the second segment in our series of articles covering the basics of the SQL standard ... BY with any select statement that might return multiple rows.

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 ...