푸

[mysql] 2개 테이블에서 중복된거라도 한개씩만 추출하기

select count( a.mb_id ) AS cnt,a.mb_id, b.mb_nick, b.mb_name, b.mb_email, b.mb_homepage, b.mb_open, a.lo_ip, a.lo_location, a.lo_url
from g4_login a left join g4_member b on (a.mb_id = b.mb_id)

GROUP BY a.mb_id
HAVING cnt >=1

order by a.lo_datetime desc<div class='small'>[이 게시물은 관리자님에 의해 2011-10-31 17:27:00 MySQL에서 이동 됨]</div>

댓글 1개

감사합니다.^^
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,187건
+
제목 글쓴이 날짜 조회
06-05-30 조회 3,488
06-05-29 조회 5,499
06-05-29 조회 3,549
06-05-28 조회 3,879
06-05-26 조회 4,578
06-05-26 조회 4,870
06-05-26 조회 4,443
06-05-24 조회 3,607
06-05-24 조회 4,189
06-05-24 조회 5,070
06-05-24 조회 4,977
06-05-23 조회 2,814
06-05-22 조회 3,280
06-05-20 조회 6,524
06-05-20 조회 7,892
06-05-18 조회 3,644
06-05-18 조회 3,210
06-05-17 조회 3,694
06-05-16 조회 4,449
06-05-15 조회 4,618
06-05-15 조회 4,083
06-05-15 조회 3,754
06-05-14 조회 5,843
06-05-14 조회 7,877
06-05-14 조회 6,157
06-05-14 조회 7,117
06-05-13 조회 3,775
06-05-13 조회 3,672
06-05-13 조회 3,399
06-05-13 조회 3,491
06-05-12 조회 5,729
06-05-12 조회 5,804
06-05-12 조회 3,730
06-05-12 조회 3,306
06-05-11 조회 3,656
06-05-11 조회 4,257
06-05-11 조회 3,984
06-05-11 조회 2,988
06-05-11 조회 3,039
06-05-11 조회 4,222
06-05-11 조회 3,440
06-05-11 조회 4,659
06-05-11 조회 3,687
06-05-11 조회 2,943
06-05-11 조회 3,551
06-05-11 조회 2,820
06-05-11 조회 2,518
06-05-11 조회 2,591
06-05-11 조회 2,914
06-05-11 조회 2,633
06-05-11 조회 2,859
06-05-11 조회 2,629
06-05-11 조회 3,033
06-05-11 조회 2,938
06-05-11 조회 2,578
06-05-11 조회 2,520
06-05-11 조회 2,437
06-05-11 조회 2,304
06-05-11 조회 2,507
06-05-11 조회 3,052
06-05-10 조회 3,550
06-05-10 조회 4,015
06-05-10 조회 3,446
06-05-10 조회 2,902
06-05-09 조회 8,234
06-05-09 조회 4,895
06-05-09 조회 3,437
06-05-09 조회 3,556
06-05-08 조회 3,974
06-05-08 조회 6,838
06-05-08 조회 6,661
06-05-08 조회 3,335
06-05-08 조회 4,425
06-05-07 조회 4,039
06-05-07 조회 3,317
06-05-07 조회 3,879
06-05-07 조회 2,677
06-05-07 조회 2,820
06-05-07 조회 2,902
06-05-07 조회 3,122
06-05-07 조회 2,805
06-05-07 조회 2,919
06-05-07 조회 2,820
06-05-07 조회 2,898
06-05-07 조회 2,622
06-05-07 조회 3,746
06-05-06 조회 3,067
06-05-06 조회 4,338
06-05-06 조회 4,418
06-05-06 조회 3,626
06-05-06 조회 3,748
06-05-06 조회 3,544
06-05-06 조회 3,802
06-05-06 조회 3,804
06-05-06 조회 4,255
06-05-06 조회 4,063
06-05-03 조회 6,417
06-05-02 조회 3,250
06-05-01 조회 3,250
06-05-01 조회 3,150