SELECT dbo.Person_ZC.ZC_ID, dbo.Person_ZC.Person_ID, dbo.Person_ZC.ZC_Date,
dbo.Person_ZC.ZC_Apprise_ID, dbo.Person_ZC.ZC_Unit_ID,
dbo.Person_ZC.ZC_Worker, dbo.Person_ZC.ZCYQ1_Date,
dbo.Person_ZC.ZCYQ1_Apprise_ID, dbo.Person_ZC.ZCYQ1_Worker,
dbo.Person_ZC.ZCYQ2_Date, dbo.Person_ZC.ZCYQ2_Apprise_ID,
dbo.Person_ZC.ZCYQ2_Unit, dbo.Person_ZC.ZCYQ2_Worker,
dbo.Person_ZC.ZCYQ3_Date, dbo.Person_ZC.ZCYQ3_Apprise_ID,
dbo.Person_ZC.ZCYQ3_Unit, dbo.Person_ZC.ZCYQ3_Worker,
dbo.Person_ZC.ZC_Note, dbo.Person_ZC.BCZC1_Date, dbo.Person_ZC.BCZC1_Unit,
dbo.Person_ZC.BCZC1_Worker, dbo.Person_ZC.BCZC1_Note,
dbo.Person_ZC.BCZC2_Date, dbo.Person_ZC.BCZC2_Unit,
dbo.Person_ZC.BCZC2_Worker, dbo.Person_ZC.BXZC2_Note,
dbo.Dict_Unit.Unit_Name, Dict_Unit_1.Unit_Name AS Expr1,
Dict_Unit_2.Unit_Name AS Expr2, Dict_Unit_3.Unit_Name AS Expr3
FROM dbo.Person_ZC INNER JOIN
dbo.Dict_Unit ON dbo.Person_ZC.ZC_Unit_ID = dbo.Dict_Unit.Unit_ID INNER JOIN
dbo.Dict_Unit Dict_Unit_1 ON
dbo.Person_ZC.ZCYQ1_Unit_ID = Dict_Unit_1.Unit_ID INNER JOIN
dbo.Dict_Unit Dict_Unit_2 ON
dbo.Person_ZC.ZCYQ2_Unit = Dict_Unit_2.Unit_ID INNER JOIN
dbo.Dict_Unit Dict_Unit_3 ON dbo.Person_ZC.ZCYQ3_Unit = Dict_Unit_3.Unit_ID
dbo.Person_ZC.ZC_Apprise_ID, dbo.Person_ZC.ZC_Unit_ID,
dbo.Person_ZC.ZC_Worker, dbo.Person_ZC.ZCYQ1_Date,
dbo.Person_ZC.ZCYQ1_Apprise_ID, dbo.Person_ZC.ZCYQ1_Worker,
dbo.Person_ZC.ZCYQ2_Date, dbo.Person_ZC.ZCYQ2_Apprise_ID,
dbo.Person_ZC.ZCYQ2_Unit, dbo.Person_ZC.ZCYQ2_Worker,
dbo.Person_ZC.ZCYQ3_Date, dbo.Person_ZC.ZCYQ3_Apprise_ID,
dbo.Person_ZC.ZCYQ3_Unit, dbo.Person_ZC.ZCYQ3_Worker,
dbo.Person_ZC.ZC_Note, dbo.Person_ZC.BCZC1_Date, dbo.Person_ZC.BCZC1_Unit,
dbo.Person_ZC.BCZC1_Worker, dbo.Person_ZC.BCZC1_Note,
dbo.Person_ZC.BCZC2_Date, dbo.Person_ZC.BCZC2_Unit,
dbo.Person_ZC.BCZC2_Worker, dbo.Person_ZC.BXZC2_Note,
dbo.Dict_Unit.Unit_Name, Dict_Unit_1.Unit_Name AS Expr1,
Dict_Unit_2.Unit_Name AS Expr2, Dict_Unit_3.Unit_Name AS Expr3
FROM dbo.Person_ZC INNER JOIN
dbo.Dict_Unit ON dbo.Person_ZC.ZC_Unit_ID = dbo.Dict_Unit.Unit_ID INNER JOIN
dbo.Dict_Unit Dict_Unit_1 ON
dbo.Person_ZC.ZCYQ1_Unit_ID = Dict_Unit_1.Unit_ID INNER JOIN
dbo.Dict_Unit Dict_Unit_2 ON
dbo.Person_ZC.ZCYQ2_Unit = Dict_Unit_2.Unit_ID INNER JOIN
dbo.Dict_Unit Dict_Unit_3 ON dbo.Person_ZC.ZCYQ3_Unit = Dict_Unit_3.Unit_ID
Dict_Unit 表就是通过Unit_ID得到Unit_Name
Person_ZC表里有多个Unit_ID1