coret-coret01

$sql = "SELECT produk, tanggal tgl, date_format(tanggal,'%d-%m-%Y') tanggal,supp_id pelaku, CONCAT(supp_id,' - ',ket) ket, no_invoice, qty FROM stok_supplier ss
JOIN stok_supplier_item ssi ON ssi.dep_id = ss.id where 1 $wherestok UNION
SELECT vtype produk,tanggal tgl, date_format(tanggal,'%d-%m-%Y') tanggal,agenid pelaku, ket, ket_voc no_invoice, jml qty FROM purchase where 1 $wherepurchase
order by tgl";

Silahkan Komentar ... !

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s