SELECT EntryCode.EntryCodeID, EntryCode.CodeAbbreviation FROM EntryCode INNER JOIN EntryCodesToFacilities ON EntryCode.EntryCodeID = EntryCodesToFacilities.EntryCodeID WHERE ...