조인쿼리

조인쿼리

 

select a.organization, a.person, a.regdate,
b.seq_num, b.uname, b.position_user,
b.phone || b.phone2 || b.phone3 phone,
b.email ||"@"|| b.email2  email,
b.mail_yn
  from meeting_seminar_new a, meeting_seminar_sub b
 where a.seq = b.seq_num