SELECT A.ID,
A.VID,
A.Vdata,
[State]=case when exists(select 1 from B C where C.Vid=B.Vid and C.State='false')
then 'false'
else 'true'
end
FROM A
INNER JOIN B ON A.VID = B.VID
A.VID,
A.Vdata,
[State]=case when exists(select 1 from B C where C.Vid=B.Vid and C.State='false')
then 'false'
else 'true'
end
FROM A
INNER JOIN B ON A.VID = B.VID
(select 1 from B C where C.Vid=B.Vid and C.State='false')“select 1” ??
SELECT A.ID,
A.VID,
A.Vdata,case b.State when true then 'True' else 'false' end as State
from A left join B on a.VID = B.VID
我用了IIf()函数也不行
上面我写的不行
你试试这个:SELECT A.ID,
A.VID,
A.Vdata,IIF(b.State,'True','false') as State from A left join B on a.VID = B.VID
A.VID,
A.Vdata,
IIf(B.State=true,true,false) as stat
from A left join B on a.VID = B.VID
这样还行,不过数据凭空多出了两行,怪了
(在多个重复的B.VID中只有一个是TRUE)tangqijun199(撒旦) 还有法子吗,结贴时我给你加到100分,谢谢