sys_person fee_table----------------- --------------------------------------------------------
person_id | name fee_id | receiveMan | deliverMan | 还有业务字段
----------------- --------------------------------------------------------
11 | 张3 500001 | 11 | 12 | ......
----------------- ---------------------------------------------------------
12 | 李四 .
----------------- . .
问题: 我想通过person_id 的关联取出sys_person中的name,而且还得用这个person表右联fee_table,请问怎么能实现阿,大虾们帮个忙
sql: select fee_table.*
,sys_person.name receiveManName
,sys_person.name deliverManName from sys_person
right outer join fee_table on
sys_person.person_id = fee_table.receiveMan
person_id | name fee_id | receiveMan | deliverMan | 还有业务字段
----------------- --------------------------------------------------------
11 | 张3 500001 | 11 | 12 | ......
----------------- ---------------------------------------------------------
12 | 李四 .
----------------- . .
问题: 我想通过person_id 的关联取出sys_person中的name,而且还得用这个person表右联fee_table,请问怎么能实现阿,大虾们帮个忙
sql: select fee_table.*
,sys_person.name receiveManName
,sys_person.name deliverManName from sys_person
right outer join fee_table on
sys_person.person_id = fee_table.receiveMan
,b.name receiveManName
,c.name deliverManName
from fee_table a
left join sys_person b on b.person_id = a.receiveMan
left join sys_person c on b.person_id = a.deliverMan
select fee_table.*
,sys_person.name receiveManName
,sys_person.name deliverManName from sys_person
right outer join fee_table on
sys_person.person_id = fee_table.receiveMan
outer join fee_table T on sys_person.person_id = T.deliverMan ??是这个意思