-
join 이 들어간 select
-
Zappy (IP: *.10.113.117)조회 수: 7938, 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 하여
번호 | 제목 | 닉네임 | 조회 | 등록일 |
---|---|---|---|---|
⇒ | Zappy | 7938 | 2006-05-30 | |
14 | Zappy | 8599 | 2006-05-03 | |
13 | Zappy | 8755 | 2006-07-31 | |
12 | Zappy | 8771 | 2007-01-29 | |
11 | Zappy | 9659 | 2006-05-03 | |
10 | Zappy | 9666 | 2007-01-29 | |
9 | Zappy | 9773 | 2006-08-05 | |
8 | Zappy | 11405 | 2006-05-30 | |
7 | Zappy | 13671 | 2007-11-17 | |
6 | Zappy | 24154 | 2009-04-12 |