topic Re: how to connect 2 tables in a SQL loading call with innerjoin in QlikView

how to connect 2 tables in a SQL loading call with innerjoin

JACKNIEKERK — Mon, 26 Jan 2026 18:19:17 GMT

i have 3 tabels

Tabel: SALES , key fields: OrderNr (12345678) , DepartmentNr(1) OrderDate (yymmdd) , ItemNr (12345678901234)

Tabel: COLOR, key fields: OrderNrYearDate ( yy12345678), OrderDepartmentNumbers (xxxxxxxxxx)

Tabel: PRODUCTS, key fields: ProductNr(12345678901234)

A typecal request could be:

Show from SALES , where OrderDate = '211209' and OrderNr > 10000 and OrderNr < 90000 and in tabel COLOR the

OrderDepartmentNumbers = ' 1 ' and OrderNrYearDate= '21' & OrderDate

then innerjoin to tabel PRODUCTS where ProductNr= SALES (ItemNr )

just don't know the correct syntax for that , thanks for help

Re: how to connect 2 tables in a SQL loading call with innerjoin

Or — Thu, 09 Dec 2021 11:53:04 GMT

Qlik will automatically join tables based on fields with identical names (including capitalization, so Item and item are two different fields). You can rename your fields to create the joins you'd like to achieve.

If you prefer, you can just load one SQL statements where all three tables are already joined - this will create a single table in Qlik with the result of the SQL.

Re: how to connect 2 tables in a SQL loading call with innerjoin

JACKNIEKERK — Thu, 09 Dec 2021 21:02:12 GMT

////If you prefer, you can just load one SQL statements where all three tables are already joined - this will create a single table in Qlik with the result of the SQL/// thats true but don't know the syntax , thats in basic my request, thankds

Re: how to connect 2 tables in a SQL loading call with innerjoin

Or — Thu, 09 Dec 2021 21:07:56 GMT

If you don't know basic SQL syntax, I'd recommend following up on that using SQL tutorials such as https://www.w3schools.com/sql/ before attempting to load data into Qlik using SQL. You'll find it difficult to use Qlik in this manner without understanding SQL basics (though you can still use Qlik to load data from files or other sources).