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

[JACKNIEKERK]

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

[Or]

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.

[JACKNIEKERK]

////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

[Or · Accepted solution]

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).