Exists subquery in qlik sense

[Labras14]

 I want to find the same query but in qlik sense. how to do?

select CustomerID, CompanyName
from customers as a
where exists
(
   select * from orders as b
   where a.CustomerID = b.CustomerID
   and ShipCountry = 'UK'
);

[Kushal_Chawda · Accepted solution]

@Labras14  First you need to create QVDs for both tables. Then use those QVDs to build logic in Qlik 

Orders:
LOAD distinct CustomerID
FROM Orders.QVD
where ShipCountry ='UK';

Left join(Orders)
LOAD CustomerID,
     CompanyName
FROM Customers.QVD;

[Labras14]

Thanks a loot!

You save my life in this moment!

[Kushal_Chawda]

@Labras14  Just changed the join type in previous post