[Solved] Everything is showing rather than what i need [closed]

by


Well, then just remove this fields from your SELECT clause :

SELECT `inmate`.`fname`
     , `inmate`.`lname`
     , `facility`.`name`  
FROM inmate LEFT JOIN `prison`.`facility_inmate` ON `inmate`.`inmate_id` = `facility_inmate`.`inmate_id` 
            LEFT JOIN `prison`.`facility` ON `facility_inmate`.`facility_id` = `facility`.`facility_id`

solved Everything is showing rather than what i need [closed]