SELECT * ,IFNULL(vs.no_a,0) as num FROM sut_data AS vm LEFT JOIN (SELECT sutid,COUNT(sutid) AS no_a FROM sut_book WHERE enddatetimeStr>NOW() AND validbook = 1 group BY sutid) AS vs ON vm.id=vs.sutid ORDER BY num ASC
两表查询--左查询(查询一一个表的id,在另一个表中出现的次数)并排序
最新推荐文章于 2022-03-19 21:15:50 发布