Below 2 basic points should get you started:
- QlikView joins tables based on field names.
- QlikView is case sensitive and the columns from the database needs to be referenced in upper case.
Below example should make it clear:
load PRIMARYKEY1 as ID,
VALUE1 as Value1
sql select primarykey1,
load PRIMARYKEY2 as ID,
VALUE2 as Value2
sql select primarykey2,
Above 2 tables will be joined based on field ID as we renamed primary key from both tables as ID.
Hope that helps,