SELECT dbo.tb_forum.id, dbo.tb_forum.title, dbo.tb_forum_style.forumstyle, dbo.tb_sub_forum.contents,
dbo.tb_forum_user.users, dbo.tb_sub_forum.first_forum, dbo.tb_forum.hf_nums, dbo.tb_forum.dates,
dbo.tb_forum_user.users_nc
FROM dbo.tb_forum INNER JOIN
dbo.tb_forum_style INNER JOIN
dbo.tb_forum_user INNER JOIN
dbo.tb_sub_forum ON dbo.tb_sub_forum.forumid = dbo.tb_forum.id ON
dbo.tb_forum_style.id = dbo.tb_sub_forum.styleid ON dbo.tb_forum.id = dbo.tb_sub_forum.forumid
WHERE (dbo.tb_sub_forum.first_forum = 1)错误提示:无法绑定由多个部分组成的标识符”dbo.tb_forum.id“
dbo.tb_forum_user.users, dbo.tb_sub_forum.first_forum, dbo.tb_forum.hf_nums, dbo.tb_forum.dates,
dbo.tb_forum_user.users_nc
FROM dbo.tb_forum INNER JOIN
dbo.tb_forum_style INNER JOIN
dbo.tb_forum_user INNER JOIN
dbo.tb_sub_forum ON dbo.tb_sub_forum.forumid = dbo.tb_forum.id ON
dbo.tb_forum_style.id = dbo.tb_sub_forum.styleid ON dbo.tb_forum.id = dbo.tb_sub_forum.forumid
WHERE (dbo.tb_sub_forum.first_forum = 1)错误提示:无法绑定由多个部分组成的标识符”dbo.tb_forum.id“
解决方案 »
- jquery如何实现第隐藏第三列所有内容
- list<t>绑定了Gridview
- 关于asp.net的使用软件VS2010的问题,求解~~~
- .net 应用程序中的服务器错误。
- 如何做像csdn那样,一有短信就从系统托盘哪儿弹出提示框?
- ASP.net 2005 中ManagementClass的命名空间是什么??
- 求VSS2005的下载地址
- 问个关于XML的DATAGRID的小问题~~~~
- 老问题,新需求!有关弹出确认窗口的!
- DELETE 语句与 COLUMN REFERENCE 约束 'FK_Orders_Employees' 冲突。该冲突发生于数据库 'Northwind',表 'Orders', column 'EmployeeID'
- 网站群WEB页面级超媒体嵌入技术的研究与实现
- 异常详细信息: System.FormatException: 输入字符串的格式不正确。
inner join C on A.id=C.id
类似这种结构。inner join on ... inner join on ...
SELECT dbo.tb_forum_style.forumstyle, dbo.tb_forum_user.users, dbo.tb_forum_user.users_nc,
dbo.tb_forum_user.users_picture, dbo.tb_sub_forum.id, dbo.tb_sub_forum.forumid, dbo.tb_sub_forum.title,
dbo.tb_sub_forum.contents, dbo.tb_sub_forum.dates, dbo.tb_sub_forum.first_forum
FROM dbo.tb_forum_style INNER JOIN dbo.tb_sub_forum ON dbo.tb_forum_style.id=dbo.tb_sub_forum.styleid
dbo.tb_forum_user INNER JOIN dbo.tb_sub_forum ON dbo.tb_forum_user.id=dbo.tb_sub_forum.authorid
INNER JOIN dbo.tb_sub_forum ON dbo.tb_forum_style.id=dbo.tb_sub_forum.styleid
inner join dbo.tb_forum_user on ....
INNER JOIN dbo.tb_sub_forum ON dbo.tb_forum_user.id=dbo.tb_sub_forum.authorid
少东西当然错了。