如: 1 AS A 250 ......... 2 BS F 200 ............ 3 DF E 300 .......... 4 AS A 250 .............. 5 BS D 200 .............. 6 DF R 500 ........... ....... 因为1和4一样,如何删掉其中的一条,用同时符合其中3个条件会不会出错
谁说在 VB 中的查询语句不能用 AND 、 OR ...??? 像这种语句 VB 都能正确无误的去执行: cSql = "SELECT barcode," + CStr(FuHao) + "*SUM(amount1) AS nNumber," + Trim(IDNameBody) + " AS IDName " _ & "FROM " + Trim(TableNameBody) + " WHERE " + StrWhereBody + " AND VAL(no1) IN (" _ & "SELECT VAL(no1) FROM " + Trim(TableNameHead) + " WHERE " + StrWhereHead + ") AND VAL(" + Trim(IDNameBody) + ") IN (" _ & "SELECT VAL(" + Trim(IDNameBase) + ") FROM " + Trim(TableNameBase) + " WHERE " + StrWhereBase + ")" _ & IIf(Trim(StrGroupBy) <> "", StrGroupBy, " GROUP BY barcode," + IDNameBody) + StrHaving + " ORDER BY barcode," + Trim(IDNameBody)
to flashrain(鱼磊) 可以用多个,你所举的例子好象是一个表内有三个字段,其中有两或多条数据完全一样,前面的1,2,3,4也是字段吗,这样只要两条数据有一个字段不同就不会多删,多个AND 两边注意有空格,变量非数值型要加''.
1 AS A 250 .........
2 BS F 200 ............
3 DF E 300 ..........
4 AS A 250 ..............
5 BS D 200 ..............
6 DF R 500 ...........
.......
因为1和4一样,如何删掉其中的一条,用同时符合其中3个条件会不会出错
像这种语句 VB 都能正确无误的去执行:
cSql = "SELECT barcode," + CStr(FuHao) + "*SUM(amount1) AS nNumber," + Trim(IDNameBody) + " AS IDName " _
& "FROM " + Trim(TableNameBody) + " WHERE " + StrWhereBody + " AND VAL(no1) IN (" _
& "SELECT VAL(no1) FROM " + Trim(TableNameHead) + " WHERE " + StrWhereHead + ") AND VAL(" + Trim(IDNameBody) + ") IN (" _
& "SELECT VAL(" + Trim(IDNameBase) + ") FROM " + Trim(TableNameBase) + " WHERE " + StrWhereBase + ")" _
& IIf(Trim(StrGroupBy) <> "", StrGroupBy, " GROUP BY barcode," + IDNameBody) + StrHaving + " ORDER BY barcode," + Trim(IDNameBody)
可以用多个,你所举的例子好象是一个表内有三个字段,其中有两或多条数据完全一样,前面的1,2,3,4也是字段吗,这样只要两条数据有一个字段不同就不会多删,多个AND 两边注意有空格,变量非数值型要加''.