select cf.id,
case when cf.statu in(0,1) then co.username when cf.statu in(2,3) then ss.username end as "创建人",
case when cf.statu in(1,2)then co.username when cf.statu in(0,3) then ss.username end as "发送人"
from cowf as cf,comuser as co,admin as ss
where cf.createid=(case when cf.statu in(0,1)then co.userid else ss.userid)
and cf.sendid=(case when cf.statu in(1,2)then co.userid else ss.userid)
cowf(
id number,
createid number,
sendid number,
statu number --状态识别ID
--0,comuser向admin发送
--1,comuser向comuser发送
--2,admin向comuser发送
--3,admin向admin发送
)
comuser(
userid number,
username varchar2(20)
)
admin(
userid number,
username varchar2(20)
)
问题是只能查询到当cowf.statu为0和2的记录,得不到1,3的记录,请问语句哪里错了?