需求:给订单表加上代理商与品牌这4列信息 SELECT t1.crm_order_id, t3.account_id, t3.account_name FROM tmp_sycpb.chenmingyang01_20250523_173207 t1 LEFT JOIN bili_sycpb.dwd_trad_cord_crm_order_a_d t4 ON t1.crm_order_id = t4.id LEFT JOIN bili_sycpb.dwd_trad_cntc_crm_contract_a_d t2 ON t4.crm_contract_id = t2.id LEFT JOIN b...