Repeating table names in a comma-JOINed FROM clause and explicit JOIN clauses emits error: Not unique table/alias
I am trying to grab multiple columns from multiple tables.
My left join for product p num table causes error:
Error Code: 1066. Not unique table/alias: 'product p num'
SELECT
tbls.SNum,tblmar.AssemPart,
tblmar.wifi,
`product p num`.`Customer Name`
FROM
floor.tbls,
manu.tblmar,
def.`product p num`
LEFT JOIN tblmar
ON tbls.PartNum = tblmar.AssemPart
LEFT JOIN `product p num`
on tblmar.AssemPart = `product p num`.`product p`
WHERE tblmar.AssemPart IS NOT NULL
AND `product p num`.`Customer Name` = 'Google'
AND tblmar.wifi = 1
ORDER BY `product p num`.`product p`;