How do I match records in first table that don't exist to records in second table on the inner join clause. For example, if I am inner joining based on office numbers but office number 90 does not exist in second table, but the closest office is 91 then how would I 'substitute' or make that match?How do I match records in first table that don'