select * from repair_plant where id in (select repair_id from repair_key_parts where part_id = ? ) and id !=? and state =1 ;,14,0
采用子查询比left join更快
最新推荐文章于 2022-05-25 17:00:16 发布
select * from repair_plant where id in (select repair_id from repair_key_parts where part_id = ? ) and id !=? and state =1 ;,14,0