Выборка 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 по нескольким ключам из разных таблиц - VBA»

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 ТИП_БАЛКОНА "
....

12   голосов, оценка 3.583 из 5


СОХРАНИТЬ ССЫЛКУ