left join select example
Example: 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
SELECT * FROM
(SELECT [column] FROM [table]) a
LEFT JOIN (SELECT [column1], [columnn2] FROM [table]) b
ON a.column = b.column1