我使用的公司集成平台进行开发，公司的平台是使用hibernate做的ORMapping
生成了一条SQL
select
*
from
( select
mdorgunit0_.ROW_ID as ROW1_74_0_,
cdcode1_.ROW_ID as ROW1_55_1_,
cdcode3_.ROW_ID as ROW1_55_2_,
cdcode4_.ROW_ID as ROW1_55_3_,
cdcode6_.ROW_ID as ROW1_55_4_,
bidistrict7_.ROW_ID as ROW1_47_5_,
cdcode9_.ROW_ID as ROW1_55_6_,
cdcode12_.ROW_ID as ROW1_55_7_,
mdorgunit0_.UNIT_TYPE1_ID as UNIT2_74_0_,
mdorgunit0_.BUSI_PLATE_ID as BUSI3_74_0_,
mdorgunit0_.LEVEL_ID as LEVEL4_74_0_,
mdorgunit0_.REG_TYPE as REG5_74_0_,
mdorgunit0_.TRADE_TYPE as TRADE6_74_0_,
mdorgunit0_.BANK as BANK74_0_,
mdorgunit0_.BANK_NO as BANK8_74_0_,
mdorgunit0_.ORG_CODE as ORG9_74_0_,
mdorgunit0_.BR_NUM as BR10_74_0_,
mdorgunit0_.TAX1_NUM as TAX11_74_0_,
mdorgunit0_.TAX2_NUM as TAX12_74_0_,
mdorgunit0_.LEGAL as LEGAL74_0_,
mdorgunit0_.DEPT_TYPE_ID as DEPT14_74_0_,
mdorgunit0_.UNIT_TYPE2_ID as UNIT15_74_0_,
mdorgunit0_.LEADER1 as LEADER16_74_0_,
mdorgunit0_.LEADER2 as LEADER17_74_0_,
mdorgunit0_.HEAD_OF as HEAD18_74_0_,
mdorgunit0_.INCEPTION_DATE as INCEPTION19_74_0_,
mdorgunit0_.DEPT_FUNCTIONS as DEPT20_74_0_,
mdorgunit0_.ADDRESS as ADDRESS74_0_,
mdorgunit0_.FOX as FOX74_0_,
mdorgunit0_.ZIP_CODE as ZIP23_74_0_,
mdorgunit0_.MAIL_ADDRESS as MAIL24_74_0_,
mdorgunit0_.CREATION_DATE as CREATION25_74_0_,
mdorgunit0_.REMARK as REMARK74_0_,
mdorgunit0_.STATUS_ID as STATUS27_74_0_,
mdorgunit0_.CREATED_BY as CREATED28_74_0_,
mdorgunit0_.CREATED_DATE as CREATED29_74_0_,
mdorgunit0_.LAST_UPD_BY as LAST30_74_0_,
mdorgunit0_.LAST_UPD_DATE as LAST31_74_0_,
mdorgunit0_.MODIFICATION_NUM as MODIFIC32_74_0_,
mdorgunit0_.RECORD_STATUS as RECORD33_74_0_,
mdorgunit0_.PARENT_ID as PARENT34_74_0_,
mdorgunit0_.CODE_ID as CODE35_74_0_,
mdorgunit0_.CITY_ID as CITY36_74_0_,
'......
from
MD_ORG_UNIT mdorgunit0_
left outer join
CD_CODE cdcode1_
on mdorgunit0_.PARENT_ID=cdcode1_.ROW_ID