关于ACCESS联合查询(SQL语句)问题
StrSql = "select 17931client.* from 17931client join 17931order on (17931client.cInstallPhone = 17931order.cInstallPhone) where 17931order.dDatetime >= #" & Trim(Combo2.Text) & "-" & Trim(Combo1.Text) & "-1# And 17931order.dDatetime <= #" & Trim(Combo2.Text) & "-" & Trim(Combo1.Text) & "-31#"
其中combo2.text获得年份,combo1.text获得月份,即查询条件为工单表中某年某月的所有客户表中的资料