When select two columns with the same name from two different tables produces incorrect results

If you have two columns named the same thing from two different joined tables, results of the second one get mashed together in the results from both columns, and not displayed correctly.
(eg, the TYPE table from interface_details and interface_addresses

How they get displayed depends on which order they are called, and neither is correct

eg:


SELECT
interface_details.type,
interface_addresses.type
FROM interface_addresses
join interface_details
vs:

SELECT
interface_addresses.type,
interface_details.type
FROM interface_addresses
join interface_details