求条3个表查询的SQL语句
表A
客户
companyID companyName
5         张明
2         张三
3         李四
4         王二

表B
          客户      运输车牌号 商品吨数     商品单价       运输单价
CarriageID companyName CarNumber GoodsTunnage GoodsUnitPrace CarriageUnitPrace
153         张明        黑B36579            3              1                 2 3 6 9
154         张明        黑B36579            4              2                 2 8 8 16
155         张明        黑B36579           10              8                 2 80 20 100
                                                                      91 34 125
88         张三        黑B36579            7              3                 2 21 14 35
89         张三        黑B36579            8              2                 2 16 16 32
                                                                      37 30 67
95         李四        黑B36579            4              4                 2 16 8 24
98         李四        黑B36579            5              6