Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I'm having some trouble with a query, unable to identify the error.

Can someone help me with this query, it's quite simple but everytime I execute it, it comes back with an error. The question is:

List and total the number of all full-time tutorial staff and their location.

(Tables) Employees (Fields) EmployeeID, FirstName, LastName (Tables) Contracts (Fields) ContractID, EmployeeID, Location, Status

SELECT COUNT(*)"Contracts"."EmployeeID", "Employees"."FirstName", "Employees"."LastName", "Contracts"."Location" 
FROM "Contracts", "Employees" 
WHERE "Contracts"."EmployeeID" = "Employees"."EmployeeID" 
AND "Contracts"."Status" = 'Full-time'