Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
knkirubakaran
Contributor III
Contributor III

SQL join syntax

Please help me the Join syntax for the below code

Select distinct

Sales_ID,

Code,

Item_No,    

LOSS_Date,

STAGE_Code,

ShippingCountry

From Cpp_Sales.APP_COMBINED

Left Join Cpp_Sales.OSC_DV ON B.OSC_ID = A.OSC_ID

Left Join Cpp_Account C ON C.ORG_ID = B.ORG_ID

Left Join Cpp_Sales_P.Item_Com ON OSC_ID = A.OSC_ID

2 Replies
YoussefBelloum
Champion
Champion

Hi,

Try to post the structures for tables (Cpp_Sales, Cpp_Account , Cpp_Sales_P) or the joining keys between them

ben_pugh
Creator
Creator

If you're only joining on one field, you can just load the tables separately. QlikView will automatically make associations between fields that have the same name.