천

2개 테이블에서 중복된거라도 한개씩만 추출하기 입니다.

· 2016-01-02 (토) 11:28:52 · 2574

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

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

프로그램

8,187건
+
제목 글쓴이 날짜 조회
16-01-11 조회 2,715
16-01-11 조회 2,692
16-01-11 조회 2,833
16-01-08 조회 2,896
16-01-08 조회 2,655
16-01-07 조회 2,659
16-01-05 조회 2,737
16-01-05 조회 2,715
16-01-05 조회 2,999
16-01-05 조회 2,966
16-01-05 조회 2,838
16-01-04 조회 2,709
16-01-04 조회 2,705
16-01-04 조회 2,662
16-01-04 조회 2,557
16-01-03 조회 3,466
16-01-03 조회 2,718
16-01-03 조회 3,179
16-01-02 조회 2,954
16-01-02 조회 2,684
16-01-02 조회 2,802
16-01-02 조회 2,575
16-01-01 조회 2,862
16-01-01 조회 2,787
16-01-01 조회 2,897
15-12-31 조회 2,638
15-12-31 조회 3,374
15-12-31 조회 3,027
15-12-31 조회 3,055
15-12-31 조회 2,777
15-12-30 조회 2,730
15-12-30 조회 3,306
15-12-30 조회 2,940
15-12-30 조회 2,851
15-12-30 조회 2,747
15-12-30 조회 2,658
15-12-29 조회 2,679
15-12-29 조회 2,916
15-12-29 조회 3,151
15-12-29 조회 2,692
15-12-28 조회 2,700
15-12-28 조회 2,727
15-12-28 조회 2,826
15-12-28 조회 2,600
15-12-27 조회 3,277
15-12-27 조회 2,740
15-12-27 조회 2,623
15-12-27 조회 2,685
15-12-26 조회 2,633
15-12-26 조회 2,715
15-12-26 조회 2,732
15-12-25 조회 3,604
15-12-25 조회 2,593
15-12-25 조회 2,605
15-12-25 조회 2,554
15-12-24 조회 3,098
15-12-24 조회 2,733
15-12-24 조회 2,734
15-12-24 조회 2,755
15-12-24 조회 2,714
15-12-23 조회 2,994
15-12-23 조회 2,694
15-12-23 조회 2,572
15-12-23 조회 2,694
15-12-23 조회 2,638
15-12-22 조회 2,819
15-12-22 조회 2,695
15-12-22 조회 2,668
15-12-22 조회 2,574
15-12-21 조회 2,596
15-12-21 조회 2,625
15-12-21 조회 2,605
15-12-20 조회 2,663
15-12-20 조회 2,818
15-12-20 조회 2,586
15-12-19 조회 2,675
15-12-19 조회 2,660
15-12-19 조회 2,667
15-12-18 조회 3,085
15-12-18 조회 2,641
15-12-18 조회 2,630
15-12-18 조회 2,602
15-12-17 조회 2,702
15-12-17 조회 2,601
15-12-17 조회 2,627
15-12-17 조회 2,584
15-12-16 조회 2,594
15-12-16 조회 2,632
15-12-16 조회 2,577
15-12-16 조회 2,794
15-12-15 조회 2,932
15-12-15 조회 2,852
15-12-15 조회 2,587
15-12-15 조회 2,578
15-12-15 조회 2,565
15-12-14 조회 2,662
15-12-14 조회 2,724
15-12-14 조회 2,541
15-12-13 조회 2,511
15-12-13 조회 2,560