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

An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine since its inception.