连表查询

• 看上一篇帖子的表结构

SELECT blogs.*,users.username,users.nickname 
    FROM blogs 
    INNER JOIN users 
    on users.id=blogs.userid

SELECT blogs.*,users.username,users.nickname 
    FROM blogs 
    INNER JOIN users 
    on users.id=blogs.userid
    WHERE users.username='Cercei'