Db Order sample

select b.idorders,
        a.namapelanggan,
        a.kotapelanggan,
        c.namaproduk,
        c.harga,
        b.jumlahorder,
        (c.harga * b.jumlahorder) as total,
        b.tglorder
       
from tbpelanggan a join tborders b  
            on a.idpelanggan = b.idpelanggan
        join tbproduk as c
                    on b.idproduk = c.idproduk
       
 order by b.idorders desc

---

Regards,

HERY PURNAMA

Certified IT Trainer

http://www.inhousetrainer.net

E-mail : inhousetrainer@yahoo.com, hery.purnama@gmail.com

 Call/ SMS/WA :  081.223344.506 , BBM : 7DC633AA

 

 

 Social Net :

 facebook.com/inhousetrainer

 twitter.com/inhousetrainer

 instagram.com/inhousetrainer

Hometown : Bandung - Jawa Barat

Please consider your environmental responsibility. Before printing this e-mail message, ask yourself whether you really need a hard copy.

---