Contents

Home Study
✔ Viewer
System/OS
2003.04.23 11:08

[sql] 내 방명록 답글 찾는 쿼리문.. (JOIN 구문)

hooni
Views 12845 Comment 0
?

Shortcut

PrevPrev Article

NextNext Article

Larger Font Smaller Font Up Down Go comment Print
?

Shortcut

PrevPrev Article

NextNext Article

Larger Font Smaller Font Up Down Go comment Print
SELECT g.no, g.name, r.no, r.num, r.name FROM guest g, guest_reply r where g.no<>r.num order by g.no desc

SELECT g.*, r.no, r.num FROM guest g INNER JOIN  guest_reply r ON g.no=r.num order by g.no desc

SELECT g.*, r.no, r.num FROM guest g INNER JOIN  guest_reply r ON g.no=r.num=NULL order by g.no desc


Facebook Twitter Google Pinterest KakaoStory Band
Up Down Go comment Print
Select Editor
?
Write with WYSIWYG Close
  1. No Image 23Apr
    by hooni
    2003/04/23 by hooni
    in System/OS
    Views 12845 

    [sql] 내 방명록 답글 찾는 쿼리문.. (JOIN 구문)

  2. No Image 23Apr
    by hooni
    2003/04/23 by hooni
    in Develop
    Views 10275 

    [c++] Window API(MFC) 오목 게임

  3. No Image 23Apr
    by hooni
    2003/04/23 by hooni
    in Develop
    Views 6682 

    [java] 스윙(swing) 인터페이스 이용해서 만든 구구단.. ㅋㅋ

  4. 23Apr
    by hooni
    2003/04/23 by hooni
    in Develop
    Views 6745 

    [c] 프로그래밍 과제..(colprint)

  5. No Image 23Apr
    by hooni
    2003/04/23 by hooni
    in Develop
    Views 7063 

    [php] 초간단 웹 카운터..

  6. No Image 23Apr
    by hooni
    2003/04/23 by hooni
    in Develop
    Views 7386 

    [jsp][php] LDAP 프로그래밍..

  7. No Image 23Apr
    by hooni
    2003/04/23 by hooni
    in Develop
    Views 7011 

    [c] C에서 MySQL DB 사용하기~

  8. No Image 23Apr
    by hooni
    2003/04/23 by hooni
    in Develop
    Views 8699 

    [php] 초간단 게시판 페이지 분할 알고리즘

  9. No Image 23Apr
    by hooni
    2003/04/23 by hooni
    in Develop
    Views 11699 

    [vbs] CD롬 뱉는 스크립트..

  10. No Image 23Apr
    by hooni
    2003/04/23 by hooni
    in Develop
    Views 6521 

    [js] 새로고침(refresh)방법과 다른 페이지 바꾸기..

  11. No Image 23Apr
    by hooni
    2003/04/23 by hooni
    in Develop
    Views 6955 

    [c] 단기과정[01/24] 정렬 알고리즘

  12. No Image 23Apr
    by hooni
    2003/04/23 by hooni
    in Develop
    Views 7226 

    [c] 단기과정[01/17] 후위연산 스택 계산기..

Write
Board Pagination Prev 1 ... 76 77 78 79 80 81 82 83 84 85 ... 98 Next
/ 98