SELECT CF_PNAME, CF_PCODE, REG_ID, WF, WF_ICON, TM_FC FROM TM_3DAY_LAND, TC_FORENEO_AREA WHERE CF_LEVEL = '1000' AND REG_ID = CF_PCODE AND TM_EF = '20100310' and substr(tm_fc,1,8)='20100310' UNION SELECT CF_PNAME, CF_PCODE, REG_ID, WF, WF_ICON, TM_FC FROM TM_3DAY_SEA, TC_FORENEO_AREA WHERE CF_LEVEL = '1000' AND REG_ID = CF_PCODE AND TM_EF = '20100310' AND TM_EF_D = '2010031055' and substr(tm_fc,1,8)='20100310' ORDER BY REG_ID , TM_FC