left join two loaded tables

[ali_hijazi]

hello I got 2 tables loaded as such

table1:

load field1, field2

sql select * from table1

table2:

load field1, field3

sql select * from table2

(the common field is field1)

what is the syntax of left join between the two loaded tables table1 and table2 ?

[kaushalview]

Hi,

table1:

load field1, field2

sql select * from table1

left join

table2:

load field1, field3

sql select * from table2

Regrads

Kaushal mehta

[ali_hijazi]

does your solution means that the table 1 and table 2 remain available but the relation between them is left join?

so does this mean that all values of field1 will appear whether ther is data related in table 2 or not?

please help?

[#4]

Yes, Kaushal is correct. All the values of Field1 from Table1 will appear regardless of the data related to table2.

Where ever table2 data is not available you`d get '-' Null() as value for respective columns.

- Sridhar

[ali_hijazi]

the problem is that the data is very huge is I do a left join the system is killed

can't I display all values of table1 in the dimensions of a pivot table despite the fact there is related values in table 2 or not?

without doing left join

[#6]

Yes, you can display. if you are not using left join between the table you`d get all the data from both the table.

i.e Field1 will have the data from both table1 and table2.

For example if you create a pivot table from only the table1 fields, you would get only the data from table1.

Linking the table in Qlikview is similar to outer join in SQL.

Hope this helps you.

- Sridhar