select a.supplier_id, b.supplier_name, c.component_name, a.quality_score, a.cost from supply_quality_cost a join suppliers b on a.supplier_id = b.supplier_id join components c on a.component_id = c.component_id where a.quality_score > 80 and a.cost < 50 order by 1, 5 主表join副表提取字段