UNION
SELECT     'ะยมขฯ๎ษ๓ล๚' AS TNAME, b.PROJECT_TYPE AS APPLY_TYPE, b.ID AS RID, b.ID AS RID, '' AS ID, a.DEAL_USER_ID AS USER_CODE, a.OP_TIME AS SEND_DATE, b.PROJECT_NAME AS TITLE, 
                      b.PHASE AS STATUS, '' AS LINKURL, '' AS FUN_CODE
FROM         PROJECT_A a INNER JOIN
                      PROJECT b ON b.ID = a.PID
WHERE     a.FLAG = 'Y'