<%
SQL = " SELECT TBRN_NM,HP_URL,EMP_NM"
SQL = SQL & " FROM("
SQL = SQL & " SELECT MAX(B.TBRN_CD) TBRN_CD,MAX(B.TBRN_NM) TBRN_NM,MAX(A.HP_URL) HP_URL,MAX(C.EMP_NM) EMP_NM,MAX(A.REG_DTE) REG_DTE"
SQL = SQL & " FROM COMM.TCM_BRN A, COMM.TCM_TBRN B,SBR_BEMP C"
SQL = SQL & " WHERE B.TBRN_CD=A.TBRN_CD"
SQL = SQL & " AND A.STATUS = '20'"
SQL = SQL & " AND A.REG_DTE IS NOT NULL"
SQL = SQL & " AND B.TBRN_CD=C.TBRN_CD"
SQL = SQL & " AND C.CONST_POSI='37' "
SQL = SQL & " GROUP BY B.TBRN_CD"
SQL = SQL & " ORDER BY REG_DTE DESC)"
SQL = SQL & " WHERE RowNum <= '6' AND TBRN_CD != '019011"
Set rec_data = OraDB.DbCreateDynaset ( SQL, cint(0) )
DO WHILE ( rec_data.Eof = false )
r_ceo_nm = rec_data.Fields("EMP_NM").Value
r_hp_url = rec_data.Fields("HP_URL").Value
r_tbrn_nm = rec_data.Fields("TBRN_NM").Value
%>
<%
Loop
set rec_data = Nothing
%>
