在sql中加入了两个表 [英] two tables joined in 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 表。



< pre lang =SQL> 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

这篇关于在sql中加入了两个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！