Question

update set from where语句的含义，以及这块sql语句的含义

INSERT INTO temp_ZCRK (zcbh,bmbh,rks )
SELECT zcbh,bmbh,sum( rks ) as rks
FROM YX_ZCRK INNER JOIN YX_ZCRKMX ON YX_ZCRK.ID = YX_ZCRKMX.djbh
WHERE YX_ZCRK.ID = [接收ID]
GROUP BY zcbh ,bmbh

Answer 1

SELECT zcbh,bmbh,sum( rks ) as rks
FROM YX_ZCRK INNER JOIN YX_ZCRKMX ON YX_ZCRK.ID = YX_ZCRKMX.djbh
WHERE YX_ZCRK.ID = [接收ID]
GROUP BY zcbh ,bmbh
把表YX_ZCRK的ID和YX_ZCRKMX的djbh一样的的数据关联
当YX_ZCRK中的ID 为[接收ID]
按照 zcbh,bmbh分组汇总rks
INSERT INTO temp_ZCRK (zcbh,bmbh,rks )--给表temp_ZCRK的zcbh,bmbh,rks 插入值

Answer 2

这段语句可以分成两部分来理解.
第一部分是SELECT 返回记录集:
该SELECT语句中使用了INNER JOIN子句,用以关联两个表.并使用GROUP BY进行分组.对RKS求合.

第二部分是INSERT:将返回的记录集插入到表Temp_ZCRK中.

Answer 3

1.更新表
update 数据表 set 字段1=值1,字段2=值2 …… 字段n=值n where 条件表达式

2.插入数据到temp表，而插入表中的数据是来自select后面的那个联合语句查出来的数据