动态SQL，求教！

有个如下图的表
CUST CUST_ID                 I_IN_C_TCM_CUSTOMER CUST_ID
CUST ADDRESS_INSTANCE_ID I_IN_C_PARTY         PARTY_ADDR
CUST CUST_ADDRESS         I_IN_C_PARTY         ADDRESS_NAME
CUST PARTY_ID         I_IN_C_TCM_CUSTOMER PARTY_ID
CUST INDUSTRY_CD         I_IN_C_TCM_CUSTOMER CUST_INDUSTRY_ID
CUST TELECOM_REGION_ID I_IN_C_TCM_CUSTOMER REGION_ID
CUST CUST_NAME         I_IN_C_PARTY         PARTY_NAME
CUST CUST_TYPE_CD         I_IN_C_TCM_CUSTOMER CUST_TYPE_ID
CUST CUST_SERV_GRADE_CD I_IN_C_TCM_CUSTOMER CUST_GRADE
CUST VIP_CARD_NBR         I_IN_C_TCM_CUSTOMER VIP_CARD
CUST CREATE_DATE         I_IN_C_TCM_CUSTOMER CREATE_DATE
CUST STATE                 I_IN_C_TCM_CUSTOMER STATE
CUST STATE_DATE         I_IN_C_TCM_CUSTOMER MODIFY_DATE
CUST VIP_FLAG         I_IN_C_TCM_CUSTOMER VIP_FLAG我建了个CURSOR读取数据，在上表中循环
CURSOR IS SELECT * FROM TR_ETL_MAPPING;
问，如何把其中表I_IN_C_TCM_CUSTOMER和表I_IN_C_PARTY对应的字段取出来，并如下
PARTY_ADDR，ADDRESS_NAME,PARTY_NAME