xxxxxxxxxx
SELECT * FROM
(SELECT [UserID] FROM [User]) a
LEFT JOIN (SELECT [TailUser], [Weight] FROM [Edge] WHERE [HeadUser] = 5043) b
ON a.UserId = b.TailUser
xxxxxxxxxx
SELECT * FROM
(SELECT [column] FROM [table]) a
LEFT JOIN (SELECT [column1], [columnn2] FROM [table]) b
ON a.column = b.column1
xxxxxxxxxx
SELECT Customers.customer_id, Customers.first_name, Orders.amount
FROM Customers
LEFT JOIN Orders
ON Customers.customer_id = Orders.customer;
xxxxxxxxxx
SELECT table1.column1, table2.column2
FROM table1
LEFT JOIN table2
ON table1.common_field = table2.common_field;