多表联查

use hippo300;
select 
    slot_ip_map.bmc,
    slot_ip_map.ip,
    slot_ip_map.slot,
    host_ip_map.hostname,
    host_loc_serial_map.disk_name
from slot_ip_map
right join host_ip_map 
        on slot_ip_map.ip=host_ip_map.ip
        and slot_ip_map.bmc="10.33.80.8"
left join host_loc_serial_map 
    on host_ip_map.hostname=host_loc_serial_map.hostname;