Five Stars

MAIN and LookUP

 I'm facing issue with joins for example:

select * from customers c,categories CA,products p,network n,pin_server pn,credit_transfer ch

where c.cust_id=p.pro_id

and  c.dest_id=CA.cat_id(+)

and ch.config_id = pn.config_id
and  pn.network_id = n.network_id(+) 

In this case which component should be considered as main..

Thanks in advance

4 REPLIES
Community Manager

Re: MAIN and LookUP

Hi
It depends the join model and the output columns. Do you want to do left outer join or inner join? Which tables do the output columns come from?

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Five Stars

Re: MAIN and LookUP

I want do both left outer join and inner join

as i mentioned in above query

and output columns come from customers c should I consider Customer C component as main...

 

 

regards,

Sumanth

Community Manager

Re: MAIN and LookUP

Hi Yes, set Customer C as main, let me know if you have further questions. Regards Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Five Stars

Re: MAIN and LookUP

Ok thank you.
Regards
Sumanth