SQL : join with tables with same fields name (eg primary id) return invalid results

When there is a possible confusion of fields, it is then necessary to list them all in the SELECT with the name of the table first (i think)