If tables selected for joining have a relation defined between them, Query and Reporting joins them automatically; see Joining Tables Automatically for more information. If the tables do not have a ...

SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from AJAX queries in joins, updates and any other SQL statement you can think of.