RE : How could write this SQL

2007-04-20 Thread Jacques Brignon
] 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 row2 a2,b1.qty, b2.qty, b3.qty row3 a3,b1.qty, b2.qty, b3.qty

Re: How could write this SQL

2007-04-20 Thread Baron Schwartz
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 row6