在access中怎样使用SQL语句对数据表创建查询？

Question

请麻烦高手写下步骤！最好举例如何创建！

Answer 1

sql="select * from 订单表"
(打开数据集)
do while not rs.eof
sql2="select * from 订单明细表 where 订单id="&rs("id")
(打开第2个数据集)
do while not rs2.eof
beizhu=rs2("beizhu")&","&beizhu
rs2.movenext
loop
rs2.close
'输出订单号和备注
response.write rs("OrderID")&"<br>"
response.write beizhu
清空备注,显示下一条订单的备注
beizhu=""
rs.movenext
loop