Why does this sql code give error 1066 (Not unique table/alias: ‘customer)?
- by aadersh patel
SELECT customer.id, customer.firstName, account.id
FROM customer, account
INNER JOIN customer
ON customer.id = account.customerId
ORDER BY customer.id
appologies for the poor editing...