MYSQL. Выборка из нескольких таблиц. Изменить Join

    SELECT
                 `contact`.*,
                     `branch_has_equipment`.*,
                 `branch_has_contact`.*,
                             `equipment`.*,
                             `customer_has_branch`.*,
                             `branch`.*,
                             `customer`.*,
                  `ip`.*
                             
                     FROM `customer`
                     INNER JOIN `customer_has_branch`
                             ON `customer`.`customer_id` = `customer_has_branch`.`customer_id`
                     INNER JOIN `branch`
                             ON `customer_has_branch`.`branch_id` = `branch`.`branch_id`
                     INNER JOIN `branch_has_equipment`
                             ON `branch`.`branch_id` = `branch_has_equipment`.`branch_id`
                     INNER JOIN `equipment`
                             ON `branch_has_equipment`.`equipment_id` = `equipment`.`equipment_id`
                     INNER JOIN `branch_has_contact`
                             ON `branch`.`branch_id` = `branch_has_contact`.`branch_id`
                     INNER JOIN `contact`
                             ON `branch_has_contact`.`contact_id` = `contact`.`contact_id`
            INNER JOIN `equipment_has_ip`
                ON `equipment`.`equipment_id` = `equipment_has_ip`.`equipment_id`
            INNER JOIN `ip`
            ON `equipment_has_ip`.`equipment_id` = `ip`.`ip_id`  
                     
            WHERE `customer`.`inservice` = 'Yes'
                    ORDER BY `customer`.`customer_name`

customer_id
customer_name
inservice
service_type
comment

branch_id
city
address

equipment_id
brand
model
connection_param
connection_type
serial_number
id
release

contact_id
name
surname
phone_mobile
phone_work
phone_other
position

customer_has_branch_id
customer_id
branch_id