PHP Indonesia - Facebook: Misi Om/Tante, Agan/Sista... :D minta bantuan don...

PHP Indonesia - Facebook PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/

Marketing Mobile Apps This online course focuses on marketing efforts that will increase your app's exposure and establish a mobile app marketing plan. Enroll today for $99. From our sponsors

Misi Om/Tante, Agan/Sista... :D minta bantuan don... Nov 16th 2013, 01:36, by Ahmad Arifin Maftuh Ahmad Arifin Maftuh 1:36am Nov 16 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; Dhedhe Poenya Aphrie 1:59am Nov 16 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

You are receiving this email because you subscribed to this feed at blogtrottr.com. If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions