select c.user_name,d.user_pic,a.org_name from A a ,B b,C c,D d where a.org_id =b.org_id and b.user_id
=c.user_id and c.user_id = d.user_id and c.user_name =? and a.org_name = ?
and d.state =?
……
[/Quote]
不好意思,可能是我之前没说明白题意。
分别根据user_name,org_name, state,也就是三个SQL语句