SELECT T2.ATTR_CODE ATTR_CODE, T1.FILE_ID || '_' || T1.FILE_NAME ATTR_VALUE FROM PIM_FILE T1, PIM_ORDER_ADD T2 ;