ISNULL的問題, 特奇怪.
CREATE TABLE TEST(TurnNo char(4),Bcxz bit)
INSERT TEST
SELECT 'T001',1 UNION
SELECT 'T002',1 UNION
SELECT 'T003',1 UNION
SELECT 'T004',1 UNION
SELECT 'T005',1
SELECT T1.TurnNo,ISNULL(T3.IsNight,0)IsNight
FROM TEST T1 LEFT JOIN
(SELECT TurnNo,1 IsNight FROM TEST WHERE BCXZ=0) T3
ON (T1.TurnNO=T3.TurnNo)
大家運行看看,結果是什么?