I have two tables joined that are supposed to be pulling in 143 records based off of facility. 142 of the facilities match with Join and work. The problem is one table has a code for just one facility that is different than the other. I just need a way to link that so it pulls into my report. information below and any info much appreciated. Dont ignore the obvious because I am not at all a SQL expert.

INNER JOIN TABLE1.Beds as nbc on bc.FacilityCode = nbc.FacilityCode

bc.FacilityCode has FACILITY A as 111 and nbc.FacilityCode has FACILITY A as 111A. That is the only discrepancy in the table. I tried writing a CASE WHEN statement but it must be where I placed it because it isnt pulling the facility into the column. Any help much appreciated.