topic Left Join in QlikView

Left Join

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 11 Oct 2016 19:09:30 GMT

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 — Tue, 11 Oct 2016 21:57:23 GMT

Hi,

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

thanks

regards

Marco