CODEWITHSUNDEEP
mysqlsql
SixTwentyFour
SixTwentyFour

Reputation: 41

MySQL help - What employees have worked more than 50 hours on a single assignment? Use a subquery?

I have 2 tables, assignment and employee. They are linked through EmployeeNumber and HoursWorked is an attribute stored in assignment. I have tried this and I get an error saying the subquery returns more than 1 row. What am I doing wrong:

SELECT e.FirstName, e.LastName
FROM employee e
WHERE (
    SELECT a.HoursWorked
    FROM assignment a
    WHERE a.HoursWorked > 50);

Upvotes: 0

Views: 104

Answers (2)

AgileTillIDie
AgileTillIDie

Reputation: 469

It looks like you're trying to do something like this:

SELECT e.FirstName, e.LastName
FROM employee
JOIN assignment on employee.EmployeeNumber = assignment.EmployeeNumber
WHERE assignment.HoursWorked > 50;

Upvotes: 1

Rimu Atkinson
Rimu Atkinson

Reputation: 777

SELECT e.FirstName, e.LastName FROM employee e WHERE e.EmployeeNumber IN ( SELECT EmployeeNumber FROM assignment a WHERE a.HoursWorked > 50);

Upvotes: 0

Related Questions