CAST
프로젝트당 오브젝트 뽑기
거나미스
2006. 12. 26. 10:06
반응형
ACC 가져오기
SELECT
*
FROM
USRPRO A, USRPROROOT C, ACC D
WHERE
A.IDUSRPRO = C.IDUSRPRO
and C.IDROOT = D.IDPRO;
KEYS 가져오기
SELECT
*
FROM
USRPRO A, USRPROROOT B, OBJPRO C, KEYS D
WHERE
A.IDUSRPRO = B.IDUSRPRO
and B.IDROOT = C.IDPRO
and C.idobj = D.idkey;
SELECT
*
FROM
USRPRO A, USRPROROOT C, ACC D
WHERE
A.IDUSRPRO = C.IDUSRPRO
and C.IDROOT = D.IDPRO;
KEYS 가져오기
SELECT
*
FROM
USRPRO A, USRPROROOT B, OBJPRO C, KEYS D
WHERE
A.IDUSRPRO = B.IDUSRPRO
and B.IDROOT = C.IDPRO
and C.idobj = D.idkey;