select statement in left join code example
Example 1: ms sql left join select
SELECT * FROM
(SELECT [column] FROM [table]) a
LEFT JOIN (SELECT [column1], [columnn2] FROM [table]) b
ON a.column = b.column1
Example 2: how to select all the field of the left join table
SELECT nutrients.*, measures.colX
FROM nutrients
LEFT JOIN measures ON nutrients.name=measures.name