mysql没有子查询!你可以这样写试试:
SELECT a.* FROM net_price a left join car_franchiser b using(franchiser_id) WHERE b.sell_area_id = 1 and a.franchiser_id is not NULL
SELECT a.* FROM net_price a left join car_franchiser b using(franchiser_id) WHERE b.sell_area_id = 1 and a.franchiser_id is not NULL
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货