Left Join

[Anonymous]

Two SQL Scripts from different servers.

Table1:

SQL

Table2:

SQL

I would like to see all records from table 1 but only the matching records from Table2. How do I accomplish this?

What I have is not working, see below

Table1:

SQL

Select *

////************////

RIGHT JOIN (Table1)

Table2:

SQL

Select *

[sunny_talwar]

You are using Right join in the shared script when you need a Left Join (as your title)

Table1:

SQL

Select *

////************////

Left JOIN (Table1)

SQL

Select *

FROM....

[MarcoWedel]

Hi,

can you share some sample data of both your tables as well as your expected result?

thanks

regards

Marco