34,590
社区成员
发帖
与我相关
我的任务
分享
INSERT c
SELECT aa.id,aa.a,(aa.b-(SELECT TOP 1 b FROM a WHERE a=aa.a-1))*bb.b,aa.c,aa.d
FROM a aa INNER JOIN b bb
ON aa.id=bb.id
WHERE aa.a=n
INSERT c
SELECT aa.id,aa.a,(aa.b-(SELECT TOP 1 b FROM a WHERE a=aa.a-1))*bb.b,aa.c,aa.d
FROM a aa INNER JOIN b bb
ON a.id=b.id
WHERE aa.a=n
insert into
c
select
a.id,a.a,(a.b-a.a) as b,a.c,a.d
from
a
join
b
on
a.id=b.id and a.id=2
INSERT INTO C
SELECT A.ID,A.A,(A.B-A.A)*B.A AS B,A.C,A.D FROM A ,B WHERE A.ID=B.ID AND A.ID=2