表查询解决思路

表查询
A表  bh     pj                            B表       bh           pj
         1        配件1                                            
         1        配件2
         1       配件3
         1       配件4
         2       配件1
         2       配件2
        .....................
我想实现的是

把A表的数据导到B表里面 实现的样子是B表      bh           pj
                                                                                          1           配件1、配件2、配件3、配件4
                                                                                          2          配件1、配件2、配件3、配件4
                                                                                        ........................................
有办法实现吗


                                       
------解决方案--------------------
',' 换成 '、'  符号打错了。