求助 , SQL 語句高手 , 路過的也來看看啊!!

[longjj]

現有 ; table a , 如下
oid uid
a 1
b 2
c 0

table b , 如下
uname uid
hanker 3
andy 8
babbi 9

當a.uid<>'0' 時 , a.uid 與 b.uid 是對應的 , a.uid = '0' 時 是指b中的所有人



條件 ; 要求傳入oid , 查詢到它的用戶name , 要用一條sql 語句寫完
請注意,是一條語句,最好是如下這種



select b.uname from a,b where ...........

[Comexe]

select b.uname from b join (b.uid=a.uid or a.uid=0) where a.oid=...

我在MS SQL 2000 上运行成功了！

^_^

[ar7_top]

select a.uname,b.uid from b a,a b where a.uid=b.uid and b.oid= 传入的Oid

[icyer]

用存储过程呀：

CREATE PROCEDURE spAB
@uid varchar(2)
AS
IF @uid != '0'
BEGIN
SELECT * FROM b
END
ELSE
BEGIN
SELECT * FROM b WHERE uid=@uid
END

GO

[losenetway]

select tb.uname from b as tb join a as ta on ta.uid=tb.uid where ta.oid=@oid
union select tb.uname from b as tb where @oid in (select uid from a where oid='b')应该差不多。