第一个：select p.auto_id,pr.username,pr.gender
第二个：select (sysdate-ud.birthday)/365 from com_partymemberinfo p left join sys_org_user pr on p.PREPARER_ID=pr.auto_id left join sys_org_user_detail ud on ud.user_id=pr.auto_id where 1=1
怎么能让1,2连成一个sql啊
[code=sql]
select p.auto_id,pr.username,(sysdate-ud.birthday)/365 age,pr.gender from com_partymemberinfo p left join sys_org_user pr on p.PREPARER_ID=pr.auto_id left join sys_org_user_detail ud on ud.user_id=pr.auto_id where 1=1
这样不行？
[code]