CODEWITHSUNDEEP
mysql
Patrick Hession
Patrick Hession

Reputation: 45

Error Code: 1054. Unknown column 'ExamQuestions.Employees.Number' in 'field list'

Below is query-

select
    Employees.Number,
    Employees.Surname,
    Employees.ProjectName
from
    ExamQuestions.Projects p,
    ExamQuestions.Employees e
where
    p.Number = e.Number;

Upvotes: 0

Views: 460

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269973

First, never use commas in the FROM clause. Always use proper, explicit JOIN syntax.

Second, you have defined table aliases, you need to use them:

SELECT e.Number, e.Surname, p.ProjectName
FROM ExamQuestions.Projects p JOIN
     ExamQuestions.Employees e
     ON p.Number = e.Number;

Presumably, the project name comes from Projects and not Employees.

Upvotes: 1

Related Questions