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 = '20081119' and substr(tm_fc,1,8)='20081119' 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 = '20081119' AND TM_EF_D = '2008111955' and substr(tm_fc,1,8)='20081119' ORDER BY REG_ID , TM_FC