本文介绍了在sql中加入了两个表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何加入两张桌子 i有文件资料表 docid docname uploadfile docid depid 和approvetype桌子 approveid approvetype i使用此查询
SELECT DocumentInfo.DocID, dbo.DocumentInfo.DocName, dbo.DocumentInfo.Uploadfile, dbo.DocType.DocType, dbo.Department.DepType, dbo.ApproveType.ApproveType AS ApproveID FROM dbo.DocumentInfo LEFT JOIN dbo.DocType ON dbo.DocumentInfo.DocTypeID = dbo.DocType.DocTypeID LEFT JOIN dbo.Depart ment ON dbo.DocumentInfo.DepID = dbo.Department.DepID它显示我的错误
多部分标识符 dbo.ApproveType.ApproveType无法绑定。解决方案
您好,您没有加入查询中的 ApproveType 表。 SELECT DocumentInfo.DocID, dbo.DocumentInfo.DocName, dbo.DocumentInfo.Uploadfile, dbo.DocType.DocType, dbo.Department.DepType, dbo.ApproveType.ApproveType AS ApproveID FROM dbo.DocumentInfo LEFT JOIN dbo.DocType ON dbo.DocumentInfo.DocTypeID = d bo.DocType.DocTypeID LEFT JOIN dbo.Department ON dbo.DocumentInfo.DepID = dbo.Department.DepID
您必须加入才能看到ApproveType列。 希望它有所帮助! :)
您的查询&中没有包含(加入)表格 ApproveType 您正试图从该表中选择一列,因此它引发了该异常。 我认为你无法执行该查询,当然DB会引发同样的错误。 你必须根据你的要求更改查询。 SELECT DocumentInfo.DocID, dbo.DocumentInfo.DocName, dbo.DocumentInfo.Uploadfile, dbo .DocType.DocType, dbo.Department.DepType, dbo.ApproveType.ApproveType AS ApproveID 来自dbo.DocumentInfo LEFT JOIN dbo.DocType ON dbo.DocumentInfo.DocTypeID = dbo.DocType.DocTypeID LEFT JOIN dbo.Department ON dbo.DocumentInfo.DepID = dbo.Department.DepID LEFT JOIN dbo.ApproveType ON dbo.ApproveType.approveid = dbo.Department.DepID
how to joined two tables i have a document info table docid docname uploadfile docid depid and approvetype table approveid approvetype i use this query
SELECT DocumentInfo.DocID, dbo.DocumentInfo.DocName, dbo.DocumentInfo.Uploadfile, dbo.DocType.DocType, dbo.Department.DepType , dbo.ApproveType.ApproveType AS ApproveID FROM dbo.DocumentInfo LEFT JOIN dbo.DocType ON dbo.DocumentInfo.DocTypeID=dbo.DocType.DocTypeID LEFT JOIN dbo.Department ON dbo.DocumentInfo.DepID=dbo.Department.DepIDand it shows me error
The multi-part identifier "dbo.ApproveType.ApproveType" could not be bound. 解决方案 Hi, you didn't join the ApproveType Table in your query. SELECT DocumentInfo.DocID, dbo.DocumentInfo.DocName, dbo.DocumentInfo.Uploadfile, dbo.DocType.DocType, dbo.Department.DepType , dbo.ApproveType.ApproveType AS ApproveID FROM dbo.DocumentInfo LEFT JOIN dbo.DocType ON dbo.DocumentInfo.DocTypeID=dbo.DocType.DocTypeID LEFT JOIN dbo.Department ON dbo.DocumentInfo.DepID=dbo.Department.DepIDYou must join it in order to see the ApproveType column. Hope it helps! :)
You didn't include(join) the table ApproveType in your query & you're trying to select a column from that table, so it raised that exception. I think you can't execute that query, surely the DB'll raise the same error. You have to change the query based on your requirement.SELECT DocumentInfo.DocID, dbo.DocumentInfo.DocName, dbo.DocumentInfo.Uploadfile, dbo.DocType.DocType, dbo.Department.DepType , dbo.ApproveType.ApproveType AS ApproveID FROM dbo.DocumentInfo LEFT JOIN dbo.DocType ON dbo.DocumentInfo.DocTypeID=dbo.DocType.DocTypeID LEFT JOIN dbo.Department ON dbo.DocumentInfo.DepID=dbo.Department.DepID LEFT JOIN dbo.ApproveType ON dbo.ApproveType.approveid=dbo.Department.DepID更多推荐
在sql中加入了两个表
发布评论