MAAF REVISI,kalau mau langsung diquery di Mysql*Plus/TOAD enakan ini mas select count(a.no_jual) t_nota, sum(b.pcs) t_pcs
from header a, detail b where a.no_jual = b.no_jual *and a.order_date between &fdate and &tdate;* 2009/3/18 yandha perdana <[email protected]> > Bisa dicoba mas, > > menurut saya mas.. > > 1. TRUNC(field_datenyah) > > kalau setahu saya apabila type sudah date, tidak perlu pakai TO_DATE(...) > > karena defaultnya sudah DD-MON-YYYY > > 2. > select no_jual, count(a.no_jual) as t_nota, sum(b.pcs) as t_pcs from header > a, detail b > where a.no_jual b.no_jual > group by no_jual > > kalau mau cari all count, tidak bisa karena anda select no_jual, maka akan > dihitung satu-satu per no_jual,kalau mau mungkin bisa coba : > > select count(a.no_jual) t_nota, sum(b.pcs) t_pcs > > from header a, detail b > > where a.no_jual = b.no_jual > > and a.no_jual IN ('...') > > atau bisa dialter di tabel field tanggal agar nanti lebih mudah pencarian > datanya..jd bisa query > > select count(a.no_jual) t_nota, sum(b.pcs) t_pcs > > from header a, detail b > > where a.no_jual = b.no_jual > > and *a.order_date between :p_fdate and :p_tdate;* > > Mohon maaf apabila kurang puas dengan jawabannya, karena saya masih baru > belajar Oracle dan SQL > > terima kasih > [Non-text portions of this message have been removed]
