一条sql语句

sql查询语句为
C/C++ code:
Select distinct a.id, a.lb,a.subject,a.nowuser, \
decode(b.done, 'ready', decode(b.xh, '1', '1', '0'), '0') nosign , a.wcrq\
from model_list a, model_mark b \
where a.author = '%s' And a.id = b.mid and a.lb in (3,4,6) \
and a.wcrq > add_months(sysdate,-1) \
order by a.wcrq desc



查询结果中 有一条记录nosign为0，一条记录nosign为1，其他都是id,lb,subject...都是一样的，我想要只有nosign为1的，就不显示为0的那条数据，应该怎么改

---

顺便问一句，这里面不能上传图片吗

---

Select distinct a.id, a.lb,a.subject,a.nowuser, \
  decode(b.done, 'ready', decode(b.xh, '1', '1')) nosign , a.wcrq\
  from model_list a, model_mark b \
  where a.author = '%s' And a.id = b.mid and a.lb in (3,4,6) \
  and a.wcrq > add_months(sysdate,-1) \
  order by a.wcrq desc

---

上传到CSDN空间相册里，再链过来
想要只有nosign为1的，就不显示为0的那条数据
没理解是什么意思

---

引用

Select distinct a.id, a.lb,a.subject,a.nowuser, \
decode(b.done, 'ready', decode(b.xh, '1', '1')) nosign , a.wcrq\
from model_list a, model_mark b \
where a.author = '%s' And a.id = b.mid and……

这样不行，如果有一