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 ...
This article is also available as a PDF download. Arranging data in a manner that’s meaningful can be a challenge. Sometimes all you need is a simple sort. Often, you need more–you need groups you can ...