Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Innner Join to exclude values in other table

Hi Experts

I have 2 Tables. One Field in a table contains a lot of data. Therefore, I would like to load only port of the data. Thus, I joined the tables to exclude part of the data:


Notiz:

SQL SELECT

notnr,

art,

thema,

notiz_typ,

txtnr

FROM EASY.notiz where notiz_typ = '258';

Inner Join (Notiz)

Text:

SQL SELECT

txtnr,

memofeld

FROM EASY.texte;

Problem is, "memofeld" is still loaded completely with 1 Mio datasets. The "Where" condition is ignored in this setting...

Thank you for your help!

Jan

2 Replies
Anonymous
Not applicable
Author

Try removing the Text: after the Inner Join (Notiz)

anbu1984
Master III
Master III

You can also join in sql

Text:

SQL SELECT

te.txtnr,

te.memofeld,

nz.notnr,

nz.art,

nz.thema,

nz.notiz_typ

FROM EASY.texte te, EASY.notiz nz

Where Trim(te.txtnr) = Trim(nz.txtnr) and nz.notiz_typ = 258;