存在A表的字段有abc B表的字段有efd;其中B表的主表id为A表的b字段B表的d字段为收费状态状态包含BZJZT_01BZJZT_02BZJZT_04BZJZT_05BZJZT_06BZJZT_07BZJZT_03收费状态等于BZJZT_03表示已收款则要求查询A表且都已收款的sql

SELECT A.* FROM A INNER JOIN B ON A.b = B.id WHERE B.d = 'BZJZT_03' GROUP BY A.a, A.b, A.c HAVING COUNT() = (SELECT COUNT() FROM B WHERE B.id = A.b AND B.d = 'BZJZT_03')