可以考虑用连接
select water_machine_com.* from water_machine_com inner join
water_machine_product on water_machine_com.com_id=water_machine_product.com_id
where water_machine_product.firttype like '%%'
select water_machine_com.* from water_machine_com inner join
water_machine_product on water_machine_com.com_id=water_machine_product.com_id
where water_machine_product.firttype like '%%'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货