Skip to content
Advertisement

How to use Left Join in subquery SQL Server?

I am trying to use left join in subquery in SQL Server. My query looks fine to me but it gives syntax error.

This is my query:

This is the error I’m getting:

enter image description here

This is my table structure:

Advertisement

Answer

As @Chris mentioned, the query is bit incomplete. I guess you are trying to do something like this:

This query worked for me. Comment to this answer if something must be changed.

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement