oracle left join 问题请教

[wanglu27]

select distinct (m.id),
l.id,
(select abbrname
from t_sys_department d
where d.zjjgdm = m.organizieuid
and d.status = '1') mname,
i.name,
l.SATISFACTIONRATE,
m.KEYWORD,
m.WRITEMAN,
m.url,
m.originaluid,
m.content,
l.year || '年' || l.month || '月',
m.title,
m.messagehappentime,
(select name from t_zwgk_item ii where ii.id = i.parentid),
m.createtime,
m.organizieuid
from t_zwgk_message m
left join t_jc_zwgk_proposal l on (m.id = l.zwgkuid)
left join t_zwgk_item i on (l.zwgkuid = i.zwgkuid)
where m.organizieuid = '732158786' order by l.SATISFACTIONRATE asc


数据可以查到，为什么别名 l 和 i 表里面的字段没数据显示

[duanzhi1984]

left join t_jc_zwgk_proposal l on (m.id = l.zwgkuid)
  left join t_zwgk_item i on (l.zwgkuid = i.zwgkuid)

因为t_jc_zwgk_proposal 中的字段zwgkuid在t_zwgk_message 表中无.
t_zwgk_item 中的字段zwgkuid在t_zwgk_message 表中无.


是不是呢

[wanglu27]

虽然不是无 但是确实是连接条件写错了 谢谢