Выборка INNER JOIN по нескольким ключам из разных таблиц - VBA

Формулировка задачи:

Есть такой запрос:

                    Листинг программы
                
 
                        
                          
                    
SQLText = "SELECT tblObject.Address, tblObject.ObjectID AS ГЌГЋГЊГ…Гђ, tblAddress.AddressName AS ГЌГЂГ‡Г‚ГЂГЌГ€Г…, " & _
    "tblAddress.AddressSign AS ГЏГђГ€Г‡ГЌГЂГЉ, tblObject.House AS Г„ГЋГЊ, tblObject.Flat AS ГЉГ‚ГЂГђГ’Г€ГђГЂ, " & _
    "tblHouse.House AS Г’Г€ГЏ_Г„ГЋГЊГЂ, tblDoor.Door AS Г’Г€ГЏ_Г„Г‚Г…ГђГ€, tblBalcony.Balcony AS Г’Г€ГЏ_ГЃГЂГ‹ГЉГЋГЌГЂ " & _
    "FROM tblAddress, tblHouse, tblDoor, tblBalcony INNER JOIN tblObject ON tblAddress.Address = tblObject.Address AND" & _
    "INNER JOIN tblObject ON tblHouse.TypeHouse = tblObject.TypeHouse AND " & _
    "INNER JOIN tblObject ON tblDoor.TypeDoor = tblObject.TypeDoor AND " & _
    "INNER JOIN tblObject ON tblBalcony.TypeBalcony = tblObject.TypeBalcony "

Не могу понять конструкцию INNER JOIN для нескольких ключей (если она есть) Суть такова: имеется таблица, к ней прикреплена куча справочников. Нужно вывести не номера ключей (0 колонка), а названия (1 колонка).

Решение задачи: «Выборка INNER JOIN по нескольким ключам из разных таблиц»

textual
                            Листинг программы 
                        
 
                        
                          
                    
S = "SELECT tblObject.Address,"
S = S & " tblObject.ObjectID AS НОМЕР,"
S = S & " tblAddress.AddressName AS НАЗВАНИЕ, "
S = S & " tblAddress.AddressSign AS ПРИЗНАК,"
S = S & " tblObject.House AS ДОМ,"
S = S & " tblObject.Flat AS КВАРТИРА, "
S = S & " tblHouse.House AS ТИП_ДОМА,"
S = S & " tblDoor.Door AS ТИП_ДВЕРИ,"
S = S & " tblBalcony.Balcony AS ТИП_БАЛКОНА "
....