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
