MySQL: 表storage_room,storage_rack
room:
rack:
sql方法一:
//经测试,此条sql 的count(*)的统计数据不准确,如需统计需另外自己写,我的是能测试即可
SELECT
a.*,b.id,b.storage_room_id,b.status,count(*),count(CASE WHEN status='2' THEN 0 END) qy,count(CASE WHEN status='3' THEN 0 END)