访问2016选择查询重复字段值

我正在尝试在MS Access 2016中进行查询,有三个类似的表:

BIB_TEXT
BIB_ID          AUTHOR          TITLE
255591          Ratnavi         saha Tamara
459194          Kantaiya        Akam elements
123456          Bob             Rules of Football   

BIB_MASTER
BIB_ID          SUPPRESS_IN_OPAC
255591          N
459194          N
123456          Y

BIB_INDEX
BIB_ID          INDEX_CODE      NORMAL_HEADING
255591          600H            Ilangaratna, 1913-1992
255591          600H            Tamara
459194          600H            Campantar
459194          600H            Tevaram
459194          600H            Cuntarar
459194          600H            Siva in Literature
123456          600H            Football United States
123456          600H            Football Rules

我得到的是:

BIB_ID  AUTHOR          TITLE           NORMAL_HEADING
255591  Ratnavi         saha Tamara     Ilangaratna, 1913-1992
255591  Ratnavi         saha Tamara     Ilangaratna, 1913-1992
459194  Kantaiya        Akam elements   Campantar   
459194  Kantaiya        Akam elements   Campantar   
459194  Kantaiya        Akam elements   Campantar   
459194  Kantaiya        Akam elements   Campantar   

我想得到的是:

BIB_ID  AUTHOR          TITLE           NORMAL_HEADING
255591  Ratnavi         saha Tamara     Ilangaratna, 1913-1992
255591  Ratnavi         saha Tamara     Tamara
459194  Kantaiya        Akam elements   Campantar   
459194  Kantaiya        Akam elements   Tevaram 
459194  Kantaiya        Akam elements   Cuntarar    
459194  Kantaiya        Akam elements   Siva in Literature

我怀疑这是与连接有关的东西,但我无法让它拉取所有正常的_heading值,无论我更改了什么。下面是SQL:

SELECT 
BIB_TEXT.BIB_ID, BIB_TEXT.AUTHOR, BIB_TEXT.TITLE, BIB_INDEX.NORMAL_HEADING
FROM 
(BIB_TEXT INNER JOIN BIB_MASTER ON BIB_TEXT.BIB_ID = BIB_MASTER.BIB_ID) INNER JOIN BIB_INDEX ON BIB_MASTER.BIB_ID = BIB_INDEX.BIB_ID
WHERE 
(((BIB_INDEX.INDEX_CODE)="600H") AND ((BIB_MASTER.SUPPRESS_IN_OPAC)="N"));

你的任何建议都将不胜感激。

谢谢, 沙质