MAIN and LookUP

[Anonymous]

 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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Hi Yes, set Customer C as main, let me know if you have further questions. Regards Shong

[Anonymous]

Ok thank you.
Regards
Sumanth