HANA版本： CREATE VIEW "IPS_VI_FldMapping" AS SELECT T0."TableID" AS "TableName",T1."AliasID" AS "FieldName",T0."FldValue" AS "Code",T0."Descr" AS "Name" FROM "UFD1" T0 INNER JOIN "CUFD" T1 ON T1."TableID"=T0."TableID" AND T1."FieldID"=T0."FieldID"; SQL版本 CREATE VIEW [IPS_VI_FldMapping] AS SELECT T0.TableID AS TableName,T1.AliasID AS FieldName,T0.FldValue AS Code,T0.Descr AS Name FROM UFD1 T0 INNER JOIN CUFD T1 ON T1.TableID=T0.TableID AND T1.FieldID=T0.FieldID 效果图：