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; ... View more