Db.Execute "delete from B " & _
" where KH='" & fg.TextMatrix(i, 2) & "' " & _
" and dttime between (select min(dttime1) from A where KH='" & fg.TextMatrix(i, 2) & "' and dttime2 = #" & fg.TextMatrix(i, 1) & "#) " & _
" and (select max(dttime2) from A where KH='" & fg.TextMatrix(i, 2) & "' and dttime2 = #" & fg.TextMatrix(i, 1) & "#) " 在SQL数据库下怎么改?
" where KH='" & fg.TextMatrix(i, 2) & "' " & _
" and dttime between (select min(dttime1) from A where KH='" & fg.TextMatrix(i, 2) & "' and dttime2 = #" & fg.TextMatrix(i, 1) & "#) " & _
" and (select max(dttime2) from A where KH='" & fg.TextMatrix(i, 2) & "' and dttime2 = #" & fg.TextMatrix(i, 1) & "#) " 在SQL数据库下怎么改?
" where KH='" & fg.TextMatrix(i, 2) & "' " & _
" and dttime between (select min(dttime1) from A where KH='" & fg.TextMatrix(i, 2) & "' and dttime2 = '" & fg.TextMatrix(i, 1) & "') " & _
" and (select max(dttime2) from A where KH='" & fg.TextMatrix(i, 2) & "' and dttime2 = '" & fg.TextMatrix(i, 1) & "') "