**************很难哦***************
如何写出如下条件的Query
FS_VATCustomerCode:
id VATCustomerCode
1 John
2 Mike
3 Jully
FS_VATProductCode:
id VATProductCode
1 Bike
2 Car
3 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 Column1 Column2 Column3
-------------------------------------------------------------------------
ProductCode John Mike Jully
Bike 2 2
Car 500 388
Tractor 149 149