I want to solve this problem in my database. I am a first-year systems student and I need your help.
SELECT pu.created, pude.purchase_price, pude.purchase_amount, pude.purchase_subtotal, su.name AS supplier_name,
pro.name AS product_name, em.full_name FROM purchases pu INNER JOIN purchase_details pude ON pu.id = pude.purchase_id
INNER JOIN products pro ON pude.product_id = pro.id INNER JOIN suppliers su ON pu.supplier_id = su.id
INNER JOIN employees em ON pu.employee_id = em.id WHERE pu.id = 2;
[Exception, Error code 1,054, SQLState 42S22] Unknown column ‘pu.employee_id’ in ‘on clause’
Nemrod Machado is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1