subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when combining data that spans multiple tables. SQL provides ...