How to perform a LEFT JOIN in SQL Server between two SELECT statements?

sql sql-server-2008 relational-database

SELECT * FROM (SELECT [UserID] FROM [User]) aLEFT JOIN (SELECT [TailUser], [Weight] FROM [Edge] WHERE [HeadUser] = 5043) bON a.UserId = b.TailUser

sql sql-server-2008 relational-database

SELECT [UserID] FROM [User] u LEFT JOIN (SELECT [TailUser], [Weight] FROM [Edge] WHERE [HeadUser] = 5043) t on t.TailUser=u.USerID

sql sql-server-2008 relational-database

select *from userleft join edgeon user.userid = edge.tailuserand edge.headuser = 5043

CodeHunter