sql to qlik script

[shravanveer]

hi can anyone convert these script into qlikview script

Select * from Category C left join  Products P ON
C.[Category ID]=P.Category left join OrderDetails OD ON
P.ProductID=OD.ProductID
Where P.ProductID between 12 and 29
Order by P.ProductID

[sidhiq91]

We can write the above query in Qlik as below.  Please mark it as solved if it has resolved your issue.

NoConcatenate
Category:
Load *, [Category ID]
from Category;

left join(Category)
Load *,Category as [Category ID],
ProductID
From Products
where ProductID>12 and ProductID<29;

Left join (Category)
Load *,ProductID
From OrderDetails