<p style="margin:0px 0px 10px;color:#333333;font-family:'Helvetica Neue', Helvetica, Arial, 'Apple SD Gothic Neo', 'Malgun Gothic', Dotdum;font-size:14px;">테이블은 총 3개가 있으며 </p> <p style="margin:0px 0px 10px;color:#333333;font-family:'Helvetica Neue', Helvetica, Arial, 'Apple SD Gothic Neo', 'Malgun Gothic', Dotdum;font-size:14px;">user 테이블의 이름,코드 group 테이블의 그룹이름, 그룹코드, 상위그룹이름, 상위그룹코드, 도메인 코드를 따오는 쿼리문을 작성해야하는데 </p> <table class="table table-bordered" style="border-spacing:0px;border-collapse:collapse;width:662px;max-width:100%;margin-bottom:20px;border:1px solid rgb(221,221,221);color:#333333;font-family:'Helvetica Neue', Helvetica, Arial, 'Apple SD Gothic Neo', 'Malgun Gothic', Dotdum;font-size:14px;"><tbody><tr><td style="padding:8px;line-height:1.42857;vertical-align:top;border:1px solid rgb(221,221,221);">user <br></td> <td style="padding:8px;line-height:1.42857;vertical-align:top;border:1px solid rgb(221,221,221);">group <br></td> <td style="padding:8px;line-height:1.42857;vertical-align:top;border:1px solid rgb(221,221,221);">domain</td></tr><tr><td style="padding:8px;line-height:1.42857;vertical-align:top;border:1px solid rgb(221,221,221);">user_id<br></td> <td style="padding:8px;line-height:1.42857;vertical-align:top;border:1px solid rgb(221,221,221);">group_id<br></td> <td style="padding:8px;line-height:1.42857;vertical-align:top;border:1px solid rgb(221,221,221);">domain_id</td></tr><tr><td style="padding:8px;line-height:1.42857;vertical-align:top;border:1px solid rgb(221,221,221);">name<br></td> <td style="padding:8px;line-height:1.42857;vertical-align:top;border:1px solid rgb(221,221,221);">name<br></td> <td style="padding:8px;line-height:1.42857;vertical-align:top;border:1px solid rgb(221,221,221);">name</td></tr><tr><td style="padding:8px;line-height:1.42857;vertical-align:top;border:1px solid rgb(221,221,221);">code<br></td> <td style="padding:8px;line-height:1.42857;vertical-align:top;border:1px solid rgb(221,221,221);">code<br></td> <td style="padding:8px;line-height:1.42857;vertical-align:top;border:1px solid rgb(221,221,221);">code</td></tr><tr><td style="padding:8px;line-height:1.42857;vertical-align:top;border:1px solid rgb(221,221,221);">group_id<br></td> <td style="padding:8px;line-height:1.42857;vertical-align:top;border:1px solid rgb(221,221,221);">domain_id<br></td> <td style="padding:8px;line-height:1.42857;vertical-align:top;border:1px solid rgb(221,221,221);"><br></td></tr><tr><td style="padding:8px;line-height:1.42857;vertical-align:top;border:1px solid rgb(221,221,221);"><br></td> <td style="padding:8px;line-height:1.42857;vertical-align:top;border:1px solid rgb(221,221,221);">parent_id<br></td> <td style="padding:8px;line-height:1.42857;vertical-align:top;border:1px solid rgb(221,221,221);"><br></td></tr></tbody></table><p style="margin:0px 0px 10px;color:#333333;font-family:'Helvetica Neue', Helvetica, Arial, 'Apple SD Gothic Neo', 'Malgun Gothic', Dotdum;font-size:14px;">SELECT user.name, user.code, g1.name "group_name", g1.code "group_code", g2.name "parent_name", g2.code "parent_code", domain.name FROM user, domain, group g1, group g2 </p> <p style="margin:0px 0px 10px;color:#333333;font-family:'Helvetica Neue', Helvetica, Arial, 'Apple SD Gothic Neo', 'Malgun Gothic', Dotdum;font-size:14px;">WHERE a.parent_id = b.group_id ;</p> <p style="margin:0px 0px 10px;color:#333333;font-family:'Helvetica Neue', Helvetica, Arial, 'Apple SD Gothic Neo', 'Malgun Gothic', Dotdum;font-size:14px;"><br></p> <p style="margin:0px 0px 10px;color:#333333;font-family:'Helvetica Neue', Helvetica, Arial, 'Apple SD Gothic Neo', 'Malgun Gothic', Dotdum;font-size:14px;">이런식으로 작성하면 쿼리가 돌아갈까요?? </p> <p style="margin:0px 0px 10px;color:#333333;font-family:'Helvetica Neue', Helvetica, Arial, 'Apple SD Gothic Neo', 'Malgun Gothic', Dotdum;font-size:14px;">제가 지금 문제로 삼고 있는 것은 group 테이블을 두 번 써야한다는 것인데 찾아보니 셀프조인으로</p> <p style="margin:0px 0px 10px;color:#333333;font-family:'Helvetica Neue', Helvetica, Arial, 'Apple SD Gothic Neo', 'Malgun Gothic', Dotdum;font-size:14px;">같은 테이블의 값을 받아올 수 있다고해서 쿼리문을 저렇게 써보았습니다.</p> <p style="margin:0px 0px 10px;color:#333333;font-family:'Helvetica Neue', Helvetica, Arial, 'Apple SD Gothic Neo', 'Malgun Gothic', Dotdum;font-size:14px;">혹시 봐주실수 있으시다면 정말 감사합니다.</p> <p style="margin:0px 0px 10px;color:#333333;font-family:'Helvetica Neue', Helvetica, Arial, 'Apple SD Gothic Neo', 'Malgun Gothic', Dotdum;font-size:14px;"><br></p>