求一个算法？

guest 表                                  t_wm_sheet_master
编号        名称1                          编号         名称2            数量
supcust_no  sup_name                      supcust_no   item_name   stock_qty
1             a                            1             b           1
2             a1                           2             b1          2
3             a3                           3             b3          3
其中   t_wm_sheet_master表supcust_no是guest的外键
结果是名称2   a a1 a3  
b       1  0  0    
b1      0  2  0
b3      0  0  3
请问如何实现啊