sql - PHP & MYSQL: How to resolve ambiguous column names in JOIN operation? - Stack Overflow
@Jason. You are correct except that php is the culprit and not mysql. If you put your JOIN in Mysql Workbench you will get three columns with the exact same name (one for each table) but not with the same data (some will be null if that table has no match...