1.如果你要查A2中有1,2,3的字段A1 结果为:a,e
select a1 from aa where a2=1
INTERSECT
select a1 from aa where a2=2
INTERSECT
select a1 from aa where a2=3
2. ..
3. ..
select a1 from aa where a2=1
INTERSECT
select a1 from aa where a2=2
INTERSECT
select a1 from aa where a2=3
2. ..
3. ..
Select DISTINCT A1 from AA where A2 in (1,2,3)如果我要查A2中有1,3的字段A1 结果为:a,d,e
Select DISTINCT A1 from AA where A2 in (1,3)如果我要查A2中有1,2的字段A1 结果为:a,c,e
Select DISTINCT A1 from AA where A2 in (1,2)
你的结果是正确的,但是还有没有更好的方法呢?
因为字段A2的内容是变化的,这样的话SQL语句也变化很大,比较麻烦。