When you execute a query using the LEFT JOIN syntax, SQL does two things: It returns all of the records from both tables that contain matching values, as defined by the ON clause.

LastName nvarchar(20)) As Json Inner Join dbo.Customers As cust On cust.LastName = Json.LastName; Of course, looking back at the Insert statement, the simplest solution is just to shove JSON data into ...