The below query duplicates entrys that do not have a match when joining the customers table. Why does this happen and how can I adjust this query?
SELECT *
FROM orders
LEFT JOIN customers ON customers.id = orders.customerid
WHERE orders.itemstatus = 'SHIPPED'
AND orders.location='".LOCATION."'
