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: 
tmumaw
Specialist II
Specialist II

Which Join ?

I have 2 tables one a customer and the other an being orders.  I need to report all customers with and without orders.  I'm only getting the ones with orders, but I need to know the others without orders.  Which join should I use?  Thanks

5 Replies
tresesco
MVP
MVP

Take the customer table first and then Left Join.

Anonymous
Not applicable

Load Customer_Code, Name, ...... from Customer;

left join

Load Customer_Code, Order_id...... from Orders;

In this way you will have all customers either having orders or not.

Regards

Nitin

amit_saini
Master III
Master III

Thom,

Yes left Join will work in this case.

Thanks,

AS

Not applicable

use outer join for getting the customer without order.

select * from customer a,order b where a.customername=b.cuomtomername(+)

tmumaw
Specialist II
Specialist II
Author

I processed all my customers and orders then I did this with no luck.

Load *

Resident customer;

outer join (customer)

load *

Resident orders

drop table orders