SQL语句问题(50分)

H

holyszq

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-05

• #1

有两个表SPxx,KCxx
字段为:
SPxx: SPbm,SPmc,MPjj,LSjg......,
KCxx: SPbm,KCsl
现在要查询 MPjj-LSjg =0 或<0并显示KCxx 里的KCsl
如果KCxx 的 KCsl 显示为 Null的话我要让它显示 '无'
这样的SQL语句应该如何写呢？

 

S

sdhxdjw

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-05

• #2

select A.*,isnull(b.kcsl,'无')
from SPxx A left outer join KCxx B on A.SPbm=B.SPbm
WHERE A.MPjj<=A.LSjg

 

P

pengjinlongex

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-05

• #3

select (case when d2.kcsl is null then '无' else d2.kcsl end) as kcsl
from spxx d1 left join kcxx d2
on d2.spbm=d1.spbm
where d1.mpjj-d1.lsjp<=0

 

T

tsb

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-05

• #4

可惜我来晚了

 

H

holyszq

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-07

• #5

谢谢!!!