This WHERE expression creates an inner join of EMPINFO and Salary based on Identification Number. To save the query as a view, select Select OK to return to the BUILD A COLUMN EXPRESSION window.

The next release of Microsoft SQL Server, announced as SQL Server 2017, is available for download in CTP2 at http://tinyurl.com/SQLvNextLinux and offers many cool new ...