在sql中加入了两个表

本文介绍了在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.DepID

and 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.DepID

You 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