<div>이름<span class="Apple-tab-span" style="white-space:pre;"> </span>회원번호<span class="Apple-tab-span" style="white-space:pre;"> </span>지역<span class="Apple-tab-span" style="white-space:pre;"> </span>전화번호<span class="Apple-tab-span" style="white-space:pre;"> </span>승인일<span class="Apple-tab-span" style="white-space:pre;"> </span>권한</div> <div>-------------------------------------------------------</div> <div>장길산<span class="Apple-tab-span" style="white-space:pre;"> </span>1234566<span class="Apple-tab-span" style="white-space:pre;"> </span>경기<span class="Apple-tab-span" style="white-space:pre;"> </span>010-2222-2222<span class="Apple-tab-span" style="white-space:pre;"> </span>2012-02-22<span class="Apple-tab-span" style="white-space:pre;"> </span>회장</div> <div><font color="#ff0000">홍길동<span class="Apple-tab-span" style="white-space:pre;"> </span>1234567<span class="Apple-tab-span" style="white-space:pre;"> </span>서울<span class="Apple-tab-span" style="white-space:pre;"> </span>010-1234-5678<span class="Apple-tab-span" style="white-space:pre;"> </span>2015-08-15<span class="Apple-tab-span" style="white-space:pre;"> </span>회원</font></div> <div><font color="#ff0000">홍길동<span class="Apple-tab-span" style="white-space:pre;"> </span>1234567<span class="Apple-tab-span" style="white-space:pre;"> </span>서울<span class="Apple-tab-span" style="white-space:pre;"> </span>010-1234-5678<span class="Apple-tab-span" style="white-space:pre;"> </span>2015-09-01<span class="Apple-tab-span" style="white-space:pre;"> </span>부회장</font></div> <div>임꺽정<span class="Apple-tab-span" style="white-space:pre;"> </span>1234568<span class="Apple-tab-span" style="white-space:pre;"> </span>천안<span class="Apple-tab-span" style="white-space:pre;"> </span>010-8282-5858<span class="Apple-tab-span" style="white-space:pre;"> </span>2015-08-16<span class="Apple-tab-span" style="white-space:pre;"> </span>회원</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>.</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>.</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>.</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>.</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>.</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>.</div> <div><br></div> <div><br></div> <div><br></div> <div>위와 같은 테이블이 있을 경우에 </div> <div><br></div> <div>홍길동의 경우 2개이기 때문에 하나만 출력해야 하는데요...</div> <div><br></div> <div>승인일을 가입일자와 동일하게 쓰고 있는데</div> <div><br></div> <div>홍길동의 데이터를 승인인은 제일 오래된걸루 (2015-08-15) 하고 권한은 제일 높은권한(부회장) 으로 해서 하나의 행으로 출력이 될까요?</div> <div><br></div> <div><br></div> <div> <div>이름<span class="Apple-tab-span" style="white-space:pre;"> </span>회원번호<span class="Apple-tab-span" style="white-space:pre;"> </span>지역<span class="Apple-tab-span" style="white-space:pre;"> </span>전화번호<span class="Apple-tab-span" style="white-space:pre;"> </span>승인일<span class="Apple-tab-span" style="white-space:pre;"> </span>권한</div> <div>-------------------------------------------------------</div> <div>장길산<span class="Apple-tab-span" style="white-space:pre;"> </span>1234566<span class="Apple-tab-span" style="white-space:pre;"> </span>경기<span class="Apple-tab-span" style="white-space:pre;"> </span>010-2222-2222<span class="Apple-tab-span" style="white-space:pre;"> </span>2012-02-22<span class="Apple-tab-span" style="white-space:pre;"> </span>회장</div> <div><font color="#ff0000">홍길동<span class="Apple-tab-span" style="white-space:pre;"> </span>1234567<span class="Apple-tab-span" style="white-space:pre;"> </span>서울<span class="Apple-tab-span" style="white-space:pre;"> </span>010-1234-5678<span class="Apple-tab-span" style="white-space:pre;"> </span>2015-08-15<span class="Apple-tab-span" style="white-space:pre;"> </span>부회장</font></div> <div>임꺽정<span class="Apple-tab-span" style="white-space:pre;"> </span>1234568<span class="Apple-tab-span" style="white-space:pre;"> </span>천안<span class="Apple-tab-span" style="white-space:pre;"> </span>010-8282-5858<span class="Apple-tab-span" style="white-space:pre;"> </span>2015-08-16<span class="Apple-tab-span" style="white-space:pre;"> </span>회원</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>.</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>.</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>.</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>.</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>.</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>.</div></div> <div><br></div> <div><br></div> <div>어떻게 쿼리를 짜야할지 막막합니다... 하아.....</div>
<a href="http://activexxx.mooo.com/ouavatar/ouavatar_menu.php" target="_blank" title="고기를 다오 고기를!!!"><img src="http://activexxx.mooo.com/ouavatar/new_ouavatar.php?start=true&rotate=&crop=&hyperlink=http%3A%2F%2Factivexxx.mooo.com%2Fouavatar%2Fouavatar_menu.php&title=%EA%B3%A0%EA%B8%B0%EB%A5%BC+%EB%8B%A4%EC%98%A4+%EA%B3%A0%EA%B8%B0%EB%A5%BC%21%21%21&step_1=&type=end&body_num=2&body_color=ffa805&oumark_color=fff047&oumark_gloss_opacity=25&squid_num=3&squid_left_direction=down&squid_right_direction=down&skin_color=ffb273&hair_num=&hair_color=301d05&blush_num=&blush_color=FF8973&brow_num=1&brow_color=301d05&eyes_num=7&eyes_color=FFFFFF&glasses_num=1&glasses_border_color=000000&glasses_lens_color=ADD8E6&glasses_opacity=10&nose_num=5&nose_color=450000&mouth_num=8&mouth_color=&tongue_color=FF6B70&bottom_num=1&bottom_color=ff9305&language=ko_kr&rtl=on&mn=638939&about1=%EC%98%A4%EB%8A%98%EB%8F%84+%EA%B3%A0%EA%B8%B0+%EB%82%B4%EC%9D%BC%EB%8F%84+%EA%B3%A0%EA%B8%B0+%EB%A7%A4%EC%9D%BC+%EA%B3%A0%EA%B8%B0%EB%A7%8C+%EB%A8%B9%EC%96%B4%EB%8F%84+%EC%82%B4%EC%9D%B4+%EC%95%88%EC%B0%8C%EB%A9%B4+%EC%A2%8B%EA%B2%A0%EB%8B%A4%21%21%21%21%E0%B2%A5_%E0%B2%A5&about2=&nick_icon=ribbon&star_color=FFA500&background_color=ADD8E6&text_color=000000&about_color=0E76DC&end=true&isold&.png" alt="고기를 다오 고기를!!!" style="margin:0 auto;display:block;"></a>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.