###sql语句的问题!谢谢大家!###
有两个表分别是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字段)
麻烦大家帮我看看,谢谢!