Proc Sql 3 Tables Left Join Help Needed

[val843]

Hi everyone,

I am just learning to code and need assistance on how to join 3 tables. I think there should be a parenthesis somewhere but cant figure it out. Thank you!

proc sql;

create table aero.affiliate_orders as

select a.ordernumber,

        a.Affiliate,

        a.Revenue,

        b.Publisher_category,

        c.new_customer

from    

    aero.clc a

left join

    aero.affiliate_cat b

left join

    aero.new_repeat_master_customer c

ON a.ordernumber=c.order_number and

    a.affiliate = b.company_name

where a.sourcetype="Affiliate"

;quit;

[RichardinOz]

Try using a separate ON clause after each left join, rather than a single combined clause after the second join.

Richard

[Reeza]

Why do you think you need parenthesis?

[TarunKumar · Accepted solution]

proc sql;

create table aero.affiliate_orders as

select a.ordernumber,

        a.Affiliate,

        a.Revenue,

        b.Publisher_category,

        c.new_customer

from  aero.clc a

left join   aero.affiliate_cat b

     on    a.affiliate = b.company_name

left join  aero.new_repeat_master_customer c

     on a.ordernumber=c.order_number

where a.sourcetype="Affiliate"

;quit;

[val843]

Thanks!