오라클 inner join

select a.id,A.PHONE,A.EMAIL,a.memo,A.STATUS,A.DEVICE,A.CREATE_DATE,b.rid,b.content,B.RTYPE,B.ADDR,B.RDATE from CYBERCVS.contact a inner join CYBERCVS.rcontact b on a.id=b.qid;