Re: how to arrange my table in another direction

[维斯 苏]

Hello.

>Please, answer next time to the list as well. In my opinion, it is
easier to prepare the create statement on the client side than
on the server. And does this table have any sense, considering the
relational model?

Sorry,I think you misunderstand my purpose,table2 is my query result,in fact my trouble is

id customer goods1 price1 goods2 price2 goods3 price3

1  mike        tv         100     car       100     bike       20

2   jin           pc         200    psp      200     x360      299

 

i can't change the table,so I want a query,after the query,the value in goods1 goods2
become the column name,then their value are price1 and price2,i try many methods,but i
can't get the result


		
---------------------------------
DO YOU YAHOO!?
  雅虎免费G邮箱－No.1的防毒防垃圾超大邮箱