有如下两个数据表:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/28170.html
tprt表,组合基本信息表,每个组合有对应的投管人和托管人;文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/28170.html
tmanager表,管理人信息表,管理人类别由o_type区分;文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/28170.html
具体表信息如下所示:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/28170.html
tprt表:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/28170.html
文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/28170.html
tmanager表:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/28170.html
文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/28170.html
现需查询出每个组合对应的托管人和投管人名称,可采用自身关联查询:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/28170.html
SELECT X.O_CODE, X.O_NAME, X.O_FULLNAME, X.INVEST_MANAGER, X.DEPOSITER,文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/28170.html
T.O_NAME AS TOU_ONAME, P.O_NAME AS TUO_ONAME文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/28170.html
FROM TPRT X文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/28170.html
LEFT JOIN TMANAGER T文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/28170.html
ON X.INVEST_MANAGER = T.O_CODE AND文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/28170.html
T.O_TYPE = '2'文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/28170.html
LEFT JOIN TMANAGER P文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/28170.html
ON X.DEPOSITER = P.O_CODE AND文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/28170.html
P.O_TYPE = '3';文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/28170.html
文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/28170.html