VB中的SQL查询语句

Question

VB编写数据库时我写到以下语句时遇到问题：
qy1.Open "SELECT * FROM " & Combo1.Text, cnn, adOpenKeyset, adLockReadOnly
上面语句能找出满足Combo1.Text的所有信息，但是我要同时满足Combo2.Text中的信息，那么上面这句该怎么改写？

Answer 1

select
count(duicuo)
from
sheet1
where
duicuo='0'//这才是统计出为0的个数然后再select
ID
from
sheet1
where
duicuo='0'//这是列出为0的全部数据ID

Answer 2

若Combo1.Text为资料表时需加上[]

qy1.Open "SELECT * FROM [" & Combo1.Text & "] where 栏位命='" & combo2.text &"'", cnn, adOpenKeyset, adLockReadOnly本回答被提问者采纳

Answer 3

难道combo1.text是表名？
qy1.Open "SELECT * FROM " & Combo1.Text & " where 字段名称='" & combo2.text &"'", cnn, adOpenKeyset, adLockReadOnly

Answer 4

qy1.Open "SELECT * FROM " & Combo1.Text & "and ..." & Combo2.Text, cnn, adOpenKeyset, adLockReadOnly

Answer 5

qy1.Open "SELECT * FROM " & Combo1.Text&" union SELECT * FROM "&Combo2.Text, cnn, adOpenKeyset, adLockReadOnly