*************暴难的问题(续)******************
如何写出如下条件的Query
FS_VATCustomerCode:
id VATCustomerCode
101 John
102 Mike
103 Jully
FS_VATProductCode:
id VATProductCode
101 Bike
102 Car
103 Tractor
FS_VATProductCustomerCombination:
VATCustomerCode VATProductCode Tax
John Bike 2
John Car 500
Mike Tractor 149
Jully Bike 2
Jully Car 388
Jully Tractor 149
希望用一个表变量,实现如下结果集:
ColumnA | ColumnB
------------------------------|-------------------------------------------
ProductCode | John Mike Jully
Bike | 2 2
Car | 500 388
Tractor | 149 149
也就是说,表变量中第二个字段ColumnB是拼串拼出来的..... 中间由六个空格格开