select o.`order_id`,o.`sale_amount`,l.`logistics_company_name` from t_order o left join t_logistics l on o.`order_id`=l.`order_id` group by o.`order_id`; 2、distinct select distinct o.`order_id`,o.`sale_amount`,l.`logistics_company_name` from t_order o left join t_logis...