CODE EXAMPLE FOR SQL

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