如何查询A表中非正常的名称列表？-灵析社区

SELECT A.id, A.name FROM A WHERE NOT EXISTS (SELECT 1 FROM B WHERE B.a_id = A.id) UNION ALL SELECT A.id, A.name FROM A JOIN B ON A.id = B.a_id WHERE B.status = 1;