yuanfang blog :: yuanfang's blog
yuanfang blog ::
yuanfang's blog

spacespace 图片 (3)
spacespace 热门文章 (0)
spacespace 音乐盒 (0)
spacespace 视频 (0)
spacespace 游戏 (0)
top
arrowNotice
line mysql 多表查询 嵌套 sampl
arrow标签
articles
linemysql 多表查询 嵌套
linemysql 多表查询 嵌套
line取出指定类别里每个类
comment
tracback
month
2008 August (3)
<< 2008 November >>
S M T W T F S
26 27 28 29 30 31 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 1 2 3 4 5 6
line
feed rss
hit 181 | 5 | 2
  blogbartagsbarguest loginbarlogoutbar  
box box
line mysql 多表查询 嵌套 sample
图片 | 08/08/22 | yuanfang
SELECT * FROM users_user WHERE uuid IN (SELECT uuid FROM jobs_status WHERE jobid='5')
bullet 关联贴0 | 回帖0
line mysql 多表查询 嵌套 sample
图片 | 08/08/22 | yuanfang
SELECT *,(SELECT COUNT(jobid) FROM jobs_status where jobid=id) AS apply_num FROM jobs WHERE id = '5'
bullet 关联贴0 | 回帖0
line 取出指定类别里每个类别最新的一条记录
图片 | 08/08/22 | yuanfang
SELECT * FROM Users WHERE UserID NOT IN (SELECT UserID FROM UserNodeList WHERE NodeID='7')

select log_ID,log_Title
from blog_content
where log_ID
               in (select max(log_ID) f
                   rom blog_content where log_CateID in ($log_CateIDS) group by log_CateID) order by log_order_id limit 0,$num
bullet 关联贴0 | 回帖0
pre / [1] / next top
box box