Companies and addresses MySQL I've got a database with 2 tables.


companies
addresses


These are my tables.
Adresses


adress_id
adress_adress
adress_adressnumber
adress_zipcode
adress_city
adress_postbus
adress_country
adress_building
adress_unit


Companies


company_id
company_name
company_adress_id
company_postadress_id


A company can have a address but maby different postal address. I want to join these addresses in 1 query but when i join them only 1 address is shown because i think they're overlapping.
What can i do make this work? I'm really struggling.

Thanks in advance.

SELECT * FROM companies as c JOIN adresses as a ON c.company_adress_id = a.adress_id JOIN adresses as postaddress ON c.company_postadress_id = postaddress.adress_id
-- ---------------------------- 
            -- Table structure for adresses 
            -- ---------------------------- 
            DROP TABLE IF EXISTS `adresses`; 
            CREATE TABLE `adresses` ( 
            `adress_id` int(11) NOT NULL AUTO_INCREMENT, 
            `adress_adress` varchar(255) COLLATE utf8_unicode_ci NOT NULL, 
            `adress_adressnumber` varchar(5) COLLATE utf8_unicode_ci NOT NULL, 
            `adress_zipcode` varchar(20) COLLATE utf8_unicode_ci NOT NULL, 
            `adress_city` varchar(30) COLLATE utf8_unicode_ci NOT NULL, 
            `adress_postbus` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, 
            `adress_country` varchar(30) COLLATE utf8_unicode_ci NOT NULL, 
            `adress_building` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL, 
            `adress_unit` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, 
            `company_id` int(11) DEFAULT NULL, 
            `addresss_role` tinyint(4) DEFAULT NULL COMMENT 'Role 1 for company may be and 2 for comapny postal, feel free', 
            PRIMARY KEY (`adress_id`) 
            ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

            -- ---------------------------- 
            -- Records of adresses 
            -- ---------------------------- 
            INSERT INTO `adresses` VALUES ('1', '1324234', '', '', '', null, '', null, null, '1', '2'); 
            INSERT INTO `adresses` VALUES ('2', '67856785678', '', '', '', null, '', null, null, '1', '1'); 

            -- ---------------------------- 
            -- Table structure for companies 
            -- ---------------------------- 
            DROP TABLE IF EXISTS `companies`; 
            CREATE TABLE `companies` ( 
            `company_id` int(11) NOT NULL AUTO_INCREMENT, 
            `company_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, 
            `company_adress_id` int(11) NOT NULL, 
            `company_postadress_id` int(11) NOT NULL, 
            PRIMARY KEY (`company_id`), 
            KEY `company_adress_id` (`company_adress_id`,`company_postadress_id`), 
            KEY `company_adress_id_2` (`company_adress_id`,`company_postadress_id`), 
            KEY `company_postadress_id` (`company_postadress_id`), 
            CONSTRAINT `address` FOREIGN KEY (`company_adress_id`) REFERENCES `adresses` (`adress_id`) ON DELETE CASCADE ON UPDATE CASCADE, 
            CONSTRAINT `postal_address` FOREIGN KEY (`company_postadress_id`) REFERENCES `adresses` (`adress_id`) ON DELETE CASCADE ON UPDATE CASCADE 
            ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

            -- ---------------------------- 
            -- Records of companies 
            -- ---------------------------- 
            INSERT INTO `companies` VALUES ('1', 'sdfgsdf', '1', '2');