หนูมีตารางแบบนี้
ขอบพระคุณทุกๆท่านค่ะ
โค๊ด:
tableName
+------+------------------------+
| ID | Name |
+------+------------------------+
| 01 | Mr.A01 |
| 02 | Mr.A02 |
| 03 | Mr.A03 |
| 04 | Mr.A04 |
| 05 | Mr.A05 |
| 06 | Mr.A06 |
| 07 | Mr.A07 |
| 08 | Mr.A08 |
+------+------------------------+
tableSalay
+-------+------+------------+-----------+
| mID | ID | Salary | Tax |
+-------+------+------------+-----------+
| 1 | 01 | 20,000.00 | 1,000.00 |
| 1 | 02 | 20,000.00 | 1,000.00 |
| 1 | 03 | 20,000.00 | 1,000.00 |
| 1 | 04 | 20,000.00 | 1,000.00 |
| 1 | 05 | 20,000.00 | 1,000.00 |
| 2 | 01 | 20,000.00 | 1,000.00 |
| 2 | 02 | 20,000.00 | 1,000.00 |
| 2 | 03 | 20,000.00 | 1,000.00 |
| 2 | 04 | 20,000.00 | 1,000.00 |
| 2 | 05 | 20,000.00 | 1,000.00 |
| 2 | 06 | 20,000.00 | 1,000.00 |
| 2 | 07 | 20,000.00 | 1,000.00 |
| 2 | 08 | 20,000.00 | 1,000.00 |
+-------+------+------------+-----------+
tableMonth
+-------+-----------+
| mID | Month |
+-------+-----------+
| 1 | 01-2014 |
| 2 | 02-2014 |
+-------+-----------+
หนูต้องการ จะ select ให้ ออกมาเป็นหน้าตาแบบนี้+------+------------------------+
| ID | Name |
+------+------------------------+
| 01 | Mr.A01 |
| 02 | Mr.A02 |
| 03 | Mr.A03 |
| 04 | Mr.A04 |
| 05 | Mr.A05 |
| 06 | Mr.A06 |
| 07 | Mr.A07 |
| 08 | Mr.A08 |
+------+------------------------+
tableSalay
+-------+------+------------+-----------+
| mID | ID | Salary | Tax |
+-------+------+------------+-----------+
| 1 | 01 | 20,000.00 | 1,000.00 |
| 1 | 02 | 20,000.00 | 1,000.00 |
| 1 | 03 | 20,000.00 | 1,000.00 |
| 1 | 04 | 20,000.00 | 1,000.00 |
| 1 | 05 | 20,000.00 | 1,000.00 |
| 2 | 01 | 20,000.00 | 1,000.00 |
| 2 | 02 | 20,000.00 | 1,000.00 |
| 2 | 03 | 20,000.00 | 1,000.00 |
| 2 | 04 | 20,000.00 | 1,000.00 |
| 2 | 05 | 20,000.00 | 1,000.00 |
| 2 | 06 | 20,000.00 | 1,000.00 |
| 2 | 07 | 20,000.00 | 1,000.00 |
| 2 | 08 | 20,000.00 | 1,000.00 |
+-------+------+------------+-----------+
tableMonth
+-------+-----------+
| mID | Month |
+-------+-----------+
| 1 | 01-2014 |
| 2 | 02-2014 |
+-------+-----------+
โค๊ด:
+------------------------+-----------+
| Name | Tax |
+------------------------+-----------+
| Mr.A01 | 2,000.00 |
| Mr.A02 | 2,000.00 |
| Mr.A03 | 2,000.00 |
| Mr.A04 | 2,000.00 |
| Mr.A05 | 2,000.00 |
| Mr.A06 | 1,000.00 |
| Mr.A07 | 1,000.00 |
| Mr.A08 | 1,000.00 |
+------------------------+-----------+
หนูจะต้องเขียน query อย่างไรค่ะ | Name | Tax |
+------------------------+-----------+
| Mr.A01 | 2,000.00 |
| Mr.A02 | 2,000.00 |
| Mr.A03 | 2,000.00 |
| Mr.A04 | 2,000.00 |
| Mr.A05 | 2,000.00 |
| Mr.A06 | 1,000.00 |
| Mr.A07 | 1,000.00 |
| Mr.A08 | 1,000.00 |
+------------------------+-----------+
ขอบพระคุณทุกๆท่านค่ะ
SELECT tableName.Name, sum(tableSalary.Tax) FROM tableName INNER JOIN tableSalary ON tableName.ID = tableSalary.ID
GROUP BY tableName.Name, tableSalary.Tax
กรณีเอา Tax มาบวกกัน
ไม่ได้คะ มันยังออกมา มี tableName.Name ซ้ำกัน
ลองตัวใหม่ที่มีการ GROUP BY เข้าไปยังครับ