请大家快帮帮忙，数据库的问题，愁死我了！ (200分)

填

填海精卫

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-29

• #21

select * from
(select kmdm,kmmc,
rlj-(select sum(rlj) from yh2 where yh2.kmdm=yh1.kmdm) as rlj
from yh1 ) AA
where AA.rlj <> 0

 

Z

zlwlove

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-11

• #22

select kmdm,kmmc,rlj-(select sum(rlj) from a1 where a2.kmdm=yh1.kmdm) from a1

 

天

天崖无爱

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-11

• #23

多人接受答案了。