＃＃＃sql语句的问题！谢谢大家！＃＃＃

[asp2006boy]

有两个表分别是anli和anli2

anli

anliming neirong anlileixing

++++++++++++++++++++++++++++++++

anli2

anliming altupian

+++++++++++++++++++
下面是我写的sql语句

sql = "select * from anli where altupian in (select * from anli2 group by anliming) and anlileixing='"&anlileixing&"'"

我想达到的目的是通过anli.anliming找到anli2.altupian(anli和anli2的共通点在anliming,因为两个表都有anliming字段)
麻烦大家帮我看看，谢谢！

[myvicy]

我想达到的目的是通过anli.anliming找到anli2.altupian(anli和anli2的共通点在anliming,因为两个表都有anliming字段)
select anli2.altupian from anli,anli2 where anli.anliming=anli2.anliming and anli.anlileixing='"&anlileixing&"'"

[ahhisoft]

sql = "select * from anli where altupian in (select anliming from anli2 group by anliming) and anlileixing='"&anlileixing&"'"

[飘零雾雨]

sql = "select altupian from anli2 where anliming in (select anliming from anli)"

[Challenger_Ican]

你的SQL语句似乎不对，建议这样写试试：
sql = "select * from anli2 where anliming in (select anliming from anli group by
anliming) and anlileixing='"&anlileixing&"'"

如果还有问题，我们再交流

[abuhome]

子查询

[asp2006boy]

sql = "select * from anli2 where anliming in (select anliming from anli group by
anliming) and anlileixing='"&anlileixing&"'"

好像接近正确了，但是我的anli2里面没有anlileixing字段。谢谢你的回复