select DISTINCT n.* from tbl_mo_number n LEFT JOIN tbl_mo_assign a on a.mo_number_id = n.id
LEFT JOIN tbl_mo_lvn_order_detail od on od.mo_number_id = n.id
LEFT JOIN tbl_mo_lvn_pool_detail pd on pd.mo_number_id = n.id
WHERE n.packet_id = 521 AND CASE 0 WHEN 1 THEN (a.id is null or a.`status` =1) AND pd.id IS NULL AND od.id is NULL
ELSE ((a.id is not null AND a.`status` = 0) OR pd.id is not null OR od.id is not null ) END
mysql sql where case
最新推荐文章于 2024-06-09 10:02:40 发布