• join 이 들어간 select
  • Zappy (IP: *.10.113.117)
    조회 수: 7936, 2006-05-30 18:00:19(2006-05-30)
  • select *


    from dbox_intro_user join dbox_member_table

             on dbox_intro_user.user_uid=dbox_member_table.no


    where intro_uid='$member[no]'


    order by regdate desc



    //dbox_intro_user.user_uid=dbox_member_table.no
    dbox_intro_user 테이블의 user_uid 와 dbox_member_table 의 no 값이 같을것 join 하여

댓글 0

번호 제목 닉네임 조회  등록일 
15 Zappy 41971 2006-05-03
14 Zappy 8591 2006-05-03
13 Zappy 9656 2006-05-03
12 Zappy 86210 2006-05-03
11 Zappy 47755 2006-05-03
10 Zappy 11400 2006-05-30
9 anonymous 148010 2006-05-30
Zappy 7936 2006-05-30
7 Zappy 46668 2006-07-31
6 Zappy 8752 2006-07-31
XE Login