从MYPAGE表中读取id到各主表查询内容的SQL

SELECT   A.UID, A.B_TYPE,B.[ID],B.TITLE ,B.DT_REG,B.REG_USER,B.YN_COMPLETE FROM PT010 AS A  INNER JOIN PT020 AS B  ON A.[ID]=B.[ID]
UNION ALL
SELECT   A.UID,A.B_TYPE,B.[ID],B.TITLE ,B.DT_REG,B.REG_USER,B.YN_COMPLETE FROM PT010 AS A  INNER JOIN PT022 AS B  ON A.[ID]=B.[ID]
UNION ALL
SELECT   A.UID,A.B_TYPE,B.[ID],B.TITLE ,B.DT_REG,B.REG_USER,B.YN_COMPLETE FROM PT010 AS A  INNER JOIN PT030 AS B  ON A.[ID]=B.[ID]
UNION ALL
SELECT   A.UID,A.B_TYPE,B.[ID],B.TITLE ,B.DT_REG,B.REG_USER,B.YN_COMPLETE FROM PT010 AS A  INNER JOIN PT032 AS B  ON A.[ID]=B.[ID]
UNION ALL
SELECT   A.UID,A.B_TYPE,B.[ID],B.TITLE ,B.DT_REG,B.REG_USER,B.YN_COMPLETE FROM PT010 AS A  INNER JOIN PT040 AS B  ON A.[ID]=B.[ID]
UNION ALL
SELECT  A.UID,A.B_TYPE,B.[ID],B.TITLE ,B.DT_REG,B.REG_USER,B.YN_COMPLETE FROM PT010 AS A  INNER JOIN PT042 AS B  ON A.[ID]=B.[ID]
UNION ALL
SELECT   A.UID,A.B_TYPE,B.[ID],B.TITLE ,B.DT_REG,B.REG_USER,B.YN_COMPLETE FROM PT010 AS A  INNER JOIN PT050 AS B  ON A.[ID]=B.[ID]
UNION ALL
SELECT   A.UID,A.B_TYPE,B.[ID],B.TITLE ,B.DT_REG,B.REG_USER,B.YN_COMPLETE FROM PT010 AS A  INNER JOIN PT060 AS B  ON A.[ID]=B.[ID]
UNION ALL
SELECT  A.UID, A.B_TYPE,B.[ID],B.STORE AS TITLE,B.DT_REG, B.REG_USER ,'''' AS YN_COMPLETE FROM PT010 AS A  INNER JOIN PT070 AS B  ON A.[ID]=B.[ID]