set primary key on loaded table

[chinmay7]

Hi,

I am using two tables table A and Table B.

Table A contains below fields.

A,B,C

Table contains 

D,E

I want to join this two tables with inner join.

Like Columns E from table B inner join with column A or column B from Table A.

How to write or condition while doing inner join?

[petter · Accepted solution]

Qlik does a natural join which means that the fields that are going to be matched have to have the same names so you don't use an ON clause like in SQL or a SQL WHERE-clause (if you use old-style joins).

You can still use a WHERE-clause for anything that is not meant to match / join the two tables.