各位老大好,我有一个数据表E,里面的字段MERGE ORDER FLAG是有些空白的,会在每天从另一个表OB_LIST_E中更新。为提高效率写了2个查询:
1、得到E里面MERGE ORDER FLAG空白而OB_LIST_E里非空白的,取ORDER_NUM
和MERGE ORDER FLAG两个字段
SELECT OB_LIST_E.[MERGE ORDER FLAG], OB_LIST_E.ORDER_NUM
FROM E INNER JOIN OB_LIST_E ON E.ORDER_NUM=OB_LIST_E.ORDER_NUM
WHERE (((E.[MERGE ORDER FLAG]) Is Null) AND ((OB_LIST_E.[MERGE ORDER FLAG]) Is Not Null));2、利用查询1的结果,更新E中的MERGE ORDER FLAG字段,ORDER_NUM是唯一的。UPDATE E INNER JOIN 找出缺少组配类型的查询 ON E.ORDER_NUM = 找出缺少组配类型的查询.ORDER_NUM SET E.[MERGE ORDER FLAG] = 找出缺少组配类型的查询.[MERGE ORDER FLAG];有没办法用1句解决?
1、得到E里面MERGE ORDER FLAG空白而OB_LIST_E里非空白的,取ORDER_NUM
和MERGE ORDER FLAG两个字段
SELECT OB_LIST_E.[MERGE ORDER FLAG], OB_LIST_E.ORDER_NUM
FROM E INNER JOIN OB_LIST_E ON E.ORDER_NUM=OB_LIST_E.ORDER_NUM
WHERE (((E.[MERGE ORDER FLAG]) Is Null) AND ((OB_LIST_E.[MERGE ORDER FLAG]) Is Not Null));2、利用查询1的结果,更新E中的MERGE ORDER FLAG字段,ORDER_NUM是唯一的。UPDATE E INNER JOIN 找出缺少组配类型的查询 ON E.ORDER_NUM = 找出缺少组配类型的查询.ORDER_NUM SET E.[MERGE ORDER FLAG] = 找出缺少组配类型的查询.[MERGE ORDER FLAG];有没办法用1句解决?
解决方案 »
- 利用vb对vissim进行编程,,出现如下问题,,求高人指点一二,在下是新人。。。
- 关于连接查询如何分组的问题
- 关于winsock的问题!
- 关于Win98下的定时器问题(一般计时器、多媒体定时器)?急!
- 超快超全的源码下载网站
- 求教VB编连连看的思路。。。。有代码可以卖的也可以。。。。(QQ:7717597)
- 怎么获取WORD表格中单元格的宽度
- 我在编写程序时,有时系统会提示内存溢出,请问是何原因,遇到此类问题该如何解决.
- ★★★ListView拖放到TreeView的问题.加急!!!★★★
- 如何在程序中实现任意删除添加的控件数组?急,急,急!
- 急!求一个PS中影印的处理算法!
- 急!求一个PS中影印的处理算法
from E a inner join OB_LIST_E b ON a.ORDER_NUM=b.ORDER_NUM
WHERE (((a.[MERGE ORDER FLAG]) Is Null) AND ((b.[MERGE ORDER FLAG]) Is Not Null));
还有,红色的这段是不是有啥问题?通不过。
SQL codeupdate a set [MERGE ORDER FLAG]=b.[MERGE ORDER FLAG]
from E a inner join OB_LIST_E b ON a.ORDER_NUM=b.ORDER_NUM
WHERE (((a.[MERGE ORDER FLAG]) Is Null) AND ((b.[MERGE ORDER FLAG]) Is Not Null));
http://115.com/file/dngeu26h#
db1.mdb