RE : How could write this SQL

L PROTECTED] > Envoyé : vendredi 20 avril 2007 14:52 > À : [EMAIL PROTECTED] > Cc : mysql@lists.mysql.com > Objet : Re: How could write this SQL > > Hi, > > wang shuming wrote: > > Hi, > > How could > > select > >row1 a1,b1.qty, b2.qty, b3.qty >

Re: How could write this SQL

Hi, wang shuming wrote: > Hi, > How could > select >row1 a1,b1.qty, b2.qty, b3.qty >row2 a2,b1.qty, b2.qty, b3.qty >row3 a3,b1.qty, b2.qty, b3.qty > ... > from a table : > > row1 a1,b1,qty > row2 a1,b2,qty > row3 a1,b3,qty > row4 a2,b1,qty > row5 a2,b2,qty