有    table1   表为
id          text
001         w
002         q
003         a
id为主健
有     table2   为
id1     id2     text
001      1       wwz
001      2       wx
001      3       wy
002       1       qq
002       2       ert
id1,id2为主健
我想得的报表形式为
table1.id      table1.text     table2.text
001            w
                                 wz
                                 wx
                                 wy
002             q 
                                 qq
                                 ert
003             a
我放了两个band    主项数据和细项数据
可结果为
table1.id      table1.text     table2.text
001            w
                                 wz
                                 wx
                                 wy
                                 qq
                                 ert
002             q 
                                 wz
                                 wx
                                 wy
                                 qq
                                 ert
003             a
                                 wz
                                 wx
                                 wy
                                 qq
                                 ert我不知道怎样把两个表联结起来
我用ADOQery联结
高分请教!!!!!!!!!!!!!!!!!!!!!
谢谢!!!!!!!!!!!!!