Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try removing the Text: after the Inner Join (Notiz)
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;