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 = '20100314' and substr(tm_fc,1,8)='20100314' 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 = '20100314' AND TM_EF_D = '2010031455' and substr(tm_fc,1,8)='20100314' ORDER BY REG_ID , TM_FC
|
![]() |
![]() |
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
![]() |