UPDATE
MTZAIK
SET
TGNCSU=TGF+ T.SJJCSU FROM MTZAIK,
(SELECT
SJJCSU
FROM
TRDCRK
WHERE
NENDDT = '200808' AND
KANRNO = '11111' AND
NYUSKB = '1' AND
RIRKNO = 3
) T
where id=1
MTZAIK
SET
TGNCSU=TGF+ T.SJJCSU FROM MTZAIK,
(SELECT
SJJCSU
FROM
TRDCRK
WHERE
NENDDT = '200808' AND
KANRNO = '11111' AND
NYUSKB = '1' AND
RIRKNO = 3
) T
where id=1
没有看见关联关系啊,仅仅加了个常数啊!
UPDATE MTZAIK
SET TGNCSU = TGF + (SELECT SJJCSU
FROM TRDCRK
WHERE NENDDT = '200808'
AND KANRNO = '11111'
AND NYUSKB = '1'
AND RIRKNO = 3) T
WHERE ID = 1;
2:表TRDCRK(T)和MTZAIK貌似没有对应关系呀,或者
SELECT
SJJCSU
FROM
TRDCRK
WHERE
NENDDT = '200808' AND
KANRNO = '11111' AND
NYUSKB = '1' AND
RIRKNO = 3 根本查询出来只有一条纪录?
MTZAIK
SET
TGNCSU=TGF+(SELECT
SJJCSU
FROM
TRDCRK
WHERE
NENDDT = '200808' AND
KANRNO = '11111' AND
NYUSKB = '1' AND
RIRKNO = 3
) T
where id=1
不知道什么原因另外他们没有关联关系
就是根据以上的写法;UPDATE
MTZAIK
SET
TGNCSU=TGF+(SELECT
SJJCSU
FROM
TRDCRK
WHERE
NENDDT = '200808' AND
KANRNO = '11111' AND
NYUSKB = '1' AND
RIRKNO = 3
) T
where id=1然后把T去掉就好用了,谢谢!
MTZAIK
SET
TGNCSU=TGF+(SELECT
SJJCSU
FROM
TRDCRK
WHERE
NENDDT = '200808' AND
KANRNO = '11111' AND
NYUSKB = '1' AND
RIRKNO = 3
)