---------------colete--------------------
| id | id_comanda | status | id_lista |
----------------------------------------
| | 21775 | 0 | 3820 |
----------------------------------------
| | 21776 | 0 | 3820 |
----------------------------------------
| | 21777 | 0 | 3820 |
----------------------------------------
-----comenzi--------
| id | taxComanda |
--------------------
|21775| 16.00 |
--------------------
|21776| 00.00 |
--------------------
|21777| 16.00 |
--------------------
我想通过从表
taxaComand
的列comenzi
中进行选择来从表id_lista
的列colete
中获取SUM,因此末尾的SUM为32.00
这是我所拥有的,但是不好。
SELECT a.id_comnda AS a_id_comanda, a.id_lista AS a_id_lista,
b.id AS b_id, b.taxaComanda AS b_taxaComanda
(SELECT sum(taxaComanda) FROM comenzi WHERE b.id = a.id_comanda AS totalTaxaComanda)
FROM colete a
INNER JOIN comenzi b ON b.id = a.id_comanda
WHERE a.id_lista = 3820
GROUP BY a.id_comanda
最佳答案
根据您的评论,除了这个我没有其他答案:
SELECT SUM(b.taxComanda )
FROM colete a
INNER JOIN comenzi b ON b.id = a.id_comanda
WHERE a.id_lista = 3820