topic Re: Left join realization in QlikView

Left join realization

krisjanis — Mon, 11 Jul 2016 09:41:17 GMT

Hello

I would like to know, how to realize this Left join type:

SELECT * FROM TableA

LEFT OUTER JOIN TableB

ON TableA.name = TableB.name

WHERE TableB.id IS null

id name id name

-- ---- -- ----

2 Monkey null null

4 Spaghetti null null

Where this middle part is excluded?

Thanks.

sushil353 — Mon, 11 Jul 2016 09:59:55 GMT

Hi,

HTH

krisjanis — Mon, 11 Jul 2016 10:38:52 GMT

Hi,

This is left join without WHERE TableB.id IS null part.

I need to keep only these entries, where are no matches...