给出一个例子:
strSQL = " SHAPE {select user from sale where shopid=" & "'" + ShopID + "'" & " and saledate>=" & "#" & saledate1 & "#" & " and saledate<=" & "#" & saledate2 & "#" & " group by user} AS Command4 APPEND ({select saledate,user,sum(qty*price) as amount from sale where shopid=" & "'" + ShopID + "'" & " and saledate>=" & "#" & saledate1 & "#" & " and saledate<=" & "#" & saledate2 & "#" & " group by saledate,user} AS Command5 RELATE 'user' TO 'user') AS Command5"
DataEnvironment1.Connection4.Open strcnn
DataEnvironment1.rsCommand4.Open strSQL, DataEnvironment1.Connection4