Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Which is the left table in the left join

Hi

If the below is the sql statement in qlikview. Then which is the left table here? I know it is simple! Still wanted to know that.

left join([table1]) select * from table2;


5 Replies
tresesco
MVP
MVP

table1

Not applicable
Author

Hi,

The left table is Table1 in you example sentence. All the records will be keep although there isn't relation with the table 2

Regards.

suniljain
Master
Master

in your case table1 is left table.

srinivasa1
Creator II
Creator II

Table1

Anonymous
Not applicable
Author

Hi.

In your case, Table1.

Regards