日期:2014-05-16  浏览次数:20453 次

拼合数据表
表A
产品名称   单价     
苹果       5
芒果       8
草莓       12
西瓜       4
香蕉       4.5
表B
用户       编号
A                  1
B                  2
C                 3

表A表B无任何关联要求得到结果
用户     编号       产品名称   单价
A                  1          苹果       5
A                  1          芒果       8
A                  1          草莓       12
A                  1          西瓜       4
A                  1          香蕉       4.5
B                  2          苹果       5
B                  2          芒果       8
B                  2          草莓       12
B                  2          西瓜       4
B                  2          香蕉       4.5
C                  2          苹果       5
C                  2          芒果       8
C                  2          草莓       12
C                  2          西瓜       4