SELECT A.CMPY_ID , A.CMPY_NM , A.BRNO , A.ADDR , A.TEL , A.FCSM_NMBR , A.RPRV_NM , A.CHGR_NM , A.CHGR_HP_NMBR , A.CHGR_EMAL , A.ADTN_NM , A.ADTN_DT , A.CHNG_NM , A.CHNG_DT , A.DEL_YN FROM TB_FCLT_CMPY A ORDER BY A.CMPY_ID SELECT * FROM TB_FCLT_CMPY