作者kojinchin (退伍了啦...)
看板Database
标题[SQL ] 请问这sql该如何下指令
时间Mon Oct 20 17:08:17 2008
首先分别有两个table为manage、member
帐号规则为上面权限者为何如"A"，其所建立的帐号即为"Ax"
如果为"A1"，下面权限为"A1x"....
member里的金额是我用sum() group 帐号 出来的
manage member
+--------+--------+----+ +--------+--------+
|管理帐号|百分比 |层级| |会员帐号|所得金额|
+--------+--------+----+ +--------+--------+
| A |100 |1 | |A111 |250 |
+--------+--------+----+ +--------+--------+
| A1 |80 |2 | |A112 |30 |
+--------+--------+----+ +--------+--------+
| A11 |70 |3 | |A121 |100 |
+--------+--------+----+ +--------+--------+
| A12 |60 |3 | |A122 |40 |
+--------+--------+----+ +--------+--------+
|......etc |.....etc
想要把他变成像这样子的table来做计算
+----+----+----+----+
|lv.1|lv.2|lv.3|cost|
+----+----+----+----+
|100 |80 |70 |250 |
+----+----+----+----+
|100 |80 |70 |30 |
+----+----+----+----+
|100 |80 |60 |100 |
+----+----+----+----+
|100 |80 |60 |40 |
+----+----+----+----+
请问这样要怎麽下指令呢？....我已经快升烟了╰(‵皿′＊)╯
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 123.195.220.18