| | Misi Om/Tante, Agan/Sista... :D
minta bantuan donk SUM untuk 2 Tabel yang berbeda... kasusnya ane gambarin seperti di gambar gan...
sampe SUM transaksi yang pertama masih OK,
select a.id, a.data, b.doc, sum(b.value) as value_1
from master a full outer join transaksi_1 b on (a.id = b.id)
group by a.id, a.data, b.doc
order by a.id;
tapi pas udah di join untuk SUM berikutnya jadi ngaco....
select a.id, a.data, b.doc, sum(b.value) as value_1, sum(c.value) as value_2
from master a full outer join transaksi_1 b on (a.id = b.id) full outer join transaksi_2 c on (a.id = c.id and b.doc = c.doc)
group by a.id, a.data, b.doc
order by a.id; |
| | kuncinya ID ya, kalo gitu gampang aja, di col value 1 masukkan script
$sum = mysql_query('select sum(value)as hasil, ID,DOC from transaksi where ID=$MD[ID]');
$v1=mysql_fetch_assco($sum);
echo $v1['hasil'];
$MD[ID] itu dari data master data yg sdh dibuat querynya |
