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

Question

I have two SELECT statements in SQL Server like these    SELECT  UserID  FROM  User    SELECT  TailUser    Weight  FROM  Edge  WHERE  HeadUser    5043    I want to perform a LEFT JOIN between these two SELECT statements on  UserID  attribute and  TailUser  attribute  I want to join existent records in second query with the corresponding records in first query and NULL value for absent records  How can I do this

User · Answer

SELECT  UserID  FROM  User  u LEFT JOIN   SELECT  TailUser    Weight  FROM  Edge  WHERE  HeadUser    5043  t on t TailUser u USerID

User · Answer

Try this   SELECT user userID  edge TailUser  edge Weight  FROM user LEFT JOIN edge ON edge HeadUser   User UserID WHERE edge HeadUser 5043   OR  AND edge HeadUser 5043   instead of WHERE clausule

User · Answer

SELECT   FROM   SELECT  UserID  FROM  User   a LEFT JOIN  SELECT  TailUser    Weight  FROM  Edge  WHERE  HeadUser    5043  b ON a UserId   b TailUser

User · Answer

select   from user left join edge on user userid   edge tailuser and edge headuser   5043

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

Examples related to sql

Examples related to sql-server-2008

Examples related to relational-database