푸

[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,188건
+
제목 글쓴이 날짜 조회
06-05-01 조회 3,140
06-05-01 조회 3,052
06-05-01 조회 3,048
06-05-01 조회 3,198
06-05-01 조회 4,356
06-05-01 조회 4,212
06-04-30 조회 4,031
06-04-30 조회 3,702
06-04-29 조회 3,787
06-04-29 조회 3,445
06-04-29 조회 3,505
06-04-29 조회 2,711
06-04-29 조회 3,391
06-04-29 조회 3,749
06-04-29 조회 3,738
06-04-29 조회 4,046
06-04-29 조회 3,880
06-04-29 조회 2,802
06-04-29 조회 2,925
06-04-29 조회 3,873
06-04-28 조회 3,276
06-04-28 조회 5,138
06-04-28 조회 3,669
06-04-28 조회 3,446
06-04-28 조회 4,642
06-04-28 조회 4,280
06-04-28 조회 3,405
06-04-27 조회 4,202
06-04-27 조회 3,391
06-04-26 조회 4,270
06-04-26 조회 4,651
06-04-25 조회 6,357
06-04-25 조회 4,262
06-04-25 조회 4,221
06-04-25 조회 3,845
06-04-25 조회 3,547
06-04-25 조회 3,829
06-04-25 조회 3,571
06-04-25 조회 3,658
06-04-25 조회 3,451
06-04-25 조회 3,815
06-04-25 조회 4,114
06-04-24 조회 4,388
06-04-24 조회 8,189
06-04-24 조회 6,297
06-04-24 조회 3,561
06-04-24 조회 6,275
06-04-24 조회 4,232
06-04-22 조회 3,592
06-04-22 조회 3,294
06-04-20 조회 4,708
06-04-20 조회 4,049
06-04-19 조회 4,404
06-04-19 조회 3,992
06-04-19 조회 4,577
06-04-18 조회 3,891
06-04-18 조회 4,603
06-04-18 조회 3,561
06-04-17 조회 5,205
06-04-17 조회 4,469
06-04-14 조회 5,269
06-04-13 조회 4,612
06-04-13 조회 4,213
06-04-13 조회 4,457
06-04-12 조회 3,554
06-04-11 조회 3,924
06-04-09 조회 3,422
06-04-08 조회 4,810
06-04-03 조회 5,831
06-03-30 조회 4,866
06-03-29 조회 2,827
06-03-27 조회 3,888
06-03-25 조회 3,525
06-03-24 조회 3,687
06-03-23 조회 5,572
06-03-21 조회 3,689
06-03-17 조회 4,232
06-03-17 조회 4,087
06-03-15 조회 4,739
06-03-15 조회 4,693
06-03-14 조회 2,939
06-03-11 조회 3,304
06-03-06 조회 3,884
06-03-06 조회 3,540
06-03-06 조회 5,506
06-03-06 조회 4,426
06-03-05 조회 5,199
06-03-04 조회 3,706
06-03-03 조회 3,566
06-03-03 조회 4,032
06-03-01 조회 3,533
06-02-24 조회 3,825
06-02-24 조회 3,539
06-02-23 조회 4,229
06-02-22 조회 2,755
06-02-22 조회 4,056
06-02-22 조회 3,357
06-02-22 조회 3,265
06-02-22 조회 3,356
06-02-19 조회 3,700