Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
krisjanis
Contributor II
Contributor II

Left join realization

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

6a0120a85dcdae970b012877702754970c-pi.png

Where this middle part is excluded?

Thanks.

2 Replies
sushil353
Master II
Master II

krisjanis
Contributor II
Contributor II
Author

Hi,

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

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