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

Visit the official Microsoft Drivers for PHP for SQL Server download page. Choose the appropriate version of the driver for your PHP version (in your case, PHP 7.3). Download the driver package ...