Hi All
Im working in a company where there are 30 products.
Each salesperson sales many items each day..
My data base looks like this
SP IDDATEITEM CODEQUANTITY
30012312/06/201124023
30012312/06/201128052
30012312/06/201135011
30015412/06/201124023
30015412/06/201136132
30035012/06/201145115
30035012/06/201159091
30035012/06/201119527
I want to make a query that displays each salesman's daily record in a row..
like this
SP IDDATEITEM CODE1QUANTITY1ITEM CODE1QUANTITY1ITEM CODE1QUANTITY1
30012312/06/2011240232805235011
30015412/06/20112402336132
30035012/06/2011451155909119527
I shall be grateful if any one helps me out..
Thank you very much
Abizer
[Non-text portions of this message have been removed]
__._,_.___
.
__,_._,___
Tidak ada komentar:
Posting Komentar