Question

求SQL语句:在查询结果里面再查询

sql = "select * from AA where aa='" & Combo1.Text & "'"
然后我还要查,在查出来的结果里面再找出bb=combo2的

sql="secect * from ??? where bb='" & combo2.text &"'"

是不是???填上sql就可以了?

Answer 1

在第一次查询里同时进行两个条件的查询就可以了。
具体我也没有试过，你可以试一下。
sql = "select * from AA where aa='" & Combo1.Text & "' and bb='"&combo2&"'"

Answer 2

可能这样更能达到你要的效果
secect * from AA where bb='" & combo2.text &"' and aa in (select aa from AA where aa='" & Combo1.Text & "')

Answer 3

sql = "select * from AA where aa='" & Combo1.Text & "' and bb='" & combo2.text &"'"