Left join realization

[krisjanis]

Hello

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

A Visual Explanation of SQL Joins

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]

Hi,

Different Join Functions in Qlikview

HTH

[krisjanis]

Hi,

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

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