[SQL ] 請問這sql該如何下指令
首先分別有兩個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
討論串 (同標題文章)