指定的字段'raterRank'可以引用SQL语句的FROM子句中列出的多个表 [英] the specified field 'raterRank' could refer to more than one table listed in the FROM clause of your SQL statement

问题描述

我知道这是一个常见的问题，我知道我可能做错了。在我们的组织中，我们有一名员工，他有一名评估员，高级评估员和评级评审员。我创建了一个名为tblRaters的单独表，并有raterID，raterFN，raterLN，
raterRank raterEmail。

I know this is a common question, and I know I am probably doing this wrong. In our organization we have an employee and he has a rater, senior rater, and rating reviewer. I created a seperate table called tblRaters and have the raterID, raterFN, raterLN, raterRank raterEmail.

在tblEmployee中我有员工信息，然后是raterID，srRaterID和reviewerID 。由于在评估者表上列出的任何人都可以是评估者，高级评估者或评论者，我想我可以从raterID到每个
raterID，srRaterID和reviewerID建立关系。

In the tblEmployee I have the employees info and then raterID, srRaterID, and reviewerID. Since anyone listed on the raters table can be a rater, senior rater or reviewer, I thought I may be able to just make a relationship from the raterID to each of the raterID, srRaterID, and reviewerID.

当我尝试运行查询时，我收到错误"指定字段'raterRank'可以引用FROM子句中列出的多个表你的SQL语句"有关如何更改我的表以解决此问题的任何想法？

When i try to run a query I get the error "the specified field 'raterRank' could refer to more than one table listed in the FROM clause of your SQL statement" Any thoughts on how to change my table to fix this issue?

推荐答案

您的查询的SQL是什么？

What is the SQL of your query?

这篇关于指定的字段'raterRank'可以引用SQL语句的FROM子句中列出的多个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！