topic Which Join ? in QlikView

Which Join ?

tmumaw — Mon, 07 Apr 2014 11:49:05 GMT

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

Re: Which Join ?

tresB — Mon, 07 Apr 2014 11:52:35 GMT

Take the customer table first and then Left Join.

Re: Which Join ?

Anonymous — Mon, 07 Apr 2014 11:55:06 GMT

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

Re: Which Join ?

amit_saini — Mon, 07 Apr 2014 12:08:45 GMT

Thom,

Yes left Join will work in this case.

Thanks,

Re: Which Join ?

Mon, 07 Apr 2014 12:32:44 GMT

use outer join for getting the customer without order.

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

Re: Which Join ?

tmumaw — Mon, 07 Apr 2014 14:43:03 GMT

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