Repeating table names in a comma-JOINed FROM clause and explicit JOIN clauses emits error: Not unique table/alias
11:38 07 Jul 2017

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`;
mysql left-join mysql-error-1066