MySQL Forums
Forum List  »  Newbie

Query help
Posted by: ryan carlson
Date: February 25, 2016 04:57PM

Trying to learn and got this from a query builder in navicat. Error is 1054 - Unknown column 'employees.id' in 'on clause' and I can't see why. here is the query:

SELECT
items.id,
items.asset_tag,
items.employee_id,
items.type_id,
items.make,
items.model,
items.type,
items.serial,
items.location,
items.notes,
types.id,
types.asset_type,
employees.id,
employees.fname,
employees.lname,
employees.email
FROM
employees ,
types
INNER JOIN items ON items.type_id = types.id AND items.employee_id = employees.id

Options: ReplyQuote


Subject
Written By
Posted
Query help
February 25, 2016 04:57PM
February 25, 2016 07:49PM
February 27, 2016 08:56AM
March 05, 2016 01:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.