INNER JOIN 4 tables in a single query. The structure of the SELECT quert explained including WHERE clause predicate and ORDER BY clause for sorting. Diagram of 4 tables is also examined.
Book/Kindle: SQL Programming & Database Design Using Microsoft SQL Server 2012 [Paperback] Kalman Toth (Author)