Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.