56,677
社区成员
发帖
与我相关
我的任务
分享
SELECT A.* FROM tbl05 AS A
INNER JOIN
(
SELECT T1.fid FROM
(
SELECT fid, COUNT(fid) AS cfid FROM tbl05
WHERE
(cod = 'a' AND vle = '12') OR
(cod = 'b' AND vle = '13') OR
(cod = 'c' AND vle = '14') OR
(cod = 'f' AND vle = '16')
GROUP BY fid
) AS T1
INNER JOIN
(
SELECT fid, COUNT(fid) AS cfid, cod, nam, vle FROM tbl05 GROUP BY fid
) AS T2
ON T1.fid = T2.fid
WHERE T1.cfid = T2.cfid
) AS B
ON A.fid = B.fid
select fid, code, .... from tbl
where
(code = 'a' and value = '12') or
(code = 'b' and value = '13') or
(code = 'c' and value = '14') or
(code = 'f' and value = '16')
多条不是太多, 就组合条件吧.