how does this join work?

[amien]

i want all records from table1 .. and only 1 column (and one additional to match) of table2. but for some reason there are more records loaded in table 2 then there are in table1. The problem is that table2 is much longer then table1 and i cant load all the records of table2 .. waste of memory

if i use a LEFT JOIN in SQL i get all records from TABLE1 with ZIP6 on TABLE2.

Thanks in advanced

LOAD

FILENO,
TNR1,
TNR2,
TNR3,
TNR4,
SQL SELECT *
FROM TABLE1;

LEFT JOIN

LOAD

ZIP6,
FILENO;
SQL SELECT *
FROM TABLE2;

[#2]

I think Exists() can be of help here

[amien]

something like this?

does this still work with left join?

LOAD
 FILENO,
 TNR1,
 TNR2,
 TNR3,
 TNR4,
SQL SELECT *
FROM TABLE1;

LEFT JOIN
LOAD

 ZIP6,
 FILENO;
SQL SELECT *
FROM TABLE2
WHERE EXISTS(FILENO);

[amien]

QlikVIew functions like exists() are not supported in SQL statements - your database and your ODBC driver have no idea about QlikView functions.

[amien · Accepted solution]

fixed this with a normal JOIN ON SQL statement .. thanks for the EXISTS tip anyway .. didnt knew that one