求SQL语句，急。

[postcha]

<ul class="mt8">
<stl:sqlContents connectionString="server=(local);uid=abc54288;pwd=efsfs;Trusted_Connection=no;database=abc54288">
<stl:queryString>SELECT TOP 5 Title,id,username FROM liveserver_blogcontent ORDER BY adddate DESC
</stl:queryString>
<li><a href="{stl.siteroot}/space/{sql.userid}/blog/{sql.id}.aspx">{sql.title}</a></li>
</stl:sqlContents>
</ul>

生成的代码是
<ul class="mt8">
<li><a href="http://blog.ssss.com/space/postcha/blog/9.aspx">这是日志标题</a></li>
<li><a href="http://blog.ssss.com/space/postcha/blog/10.aspx">这是日志标题</a></li>
<li><a href="http://blog.ssss.com/space/postcha/blog/11.aspx">这是日志标题</a></li>
<li><a href="http://blog.ssss.com/space/postcha/blog/55.aspx">这是日志标题</a></li>
<li><a href="http://blog.ssss.com/space/postcha/blog/56.aspx">这是日志标题</a></li>
</ul>

现在的问题是liveserver_blogcontent中的username字段是关联到另外一个表的username字段，该如何写sql语句呢？

附：
liveserver_blogcontent表


liveserver_users表


求解。

[TheGodOfGods]

看不到表结构啊，用join不行？

[炽焰12]

select * from liveserver_blogcontent lb inner jion liveserver_users lu
on bl.username=lu.username

[postcha]

不好意思<li><a href="{stl.siteroot}/space/{sql.userid}/blog/{sql.id}.aspx">{sql.title}</a></li>中的{sql.userid}应为{sql.username}，笔误。

[jwdream2008]

SELECT TOP 5 Title,id,A.username FROM liveserver_blogcontent A ,liveserver_users B where A.username=B.username  ORDER BY adddate DESC

????

[永生天地]

SELECT TOP 5 Title,id,username
FROM liveserver_blogcontent a,liveserver_users b
where a.username=b.username
ORDER BY adddate DESC

是这样？？？

[postcha]

[Quote=引用 5 楼 xys_777 的回复:]

SELECT TOP 5 Title,id,username
FROM liveserver_blogcontent a,liveserver_users b
where a.username=b.username
ORDER BY adddate DESC

是这样？？？
[/Quote]

报 列名 'UserName' 不明确。 的错误。

[ff284996867]

SELECT TOP 5 Title,id,a.username
FROM liveserver_blogcontent a,liveserver_users b
where a.username=b.username
ORDER BY adddate DESC

[TheGodOfGods]

SELECT TOP 5 Title,id,a.username
FROM liveserver_blogcontent a,liveserver_users b
where a.username=b.username
ORDER BY adddate DESC

如果是这样的话，因为两表都有username，加"a."前缀就行了

[永生天地]

查所有数据看看

SELECT TOP 5 *
FROM liveserver_blogcontent a,liveserver_users b
where a.username=b.username
ORDER BY adddate DESC