saya ingin coba memberi solusi,yg sy ketahui ada 2 cara:1 dgn inner join n ke 2 dgn where.
saya akan coba dgn delete detailtable dgn where
delete from detailtable where detailtable.notrans=mastertable.notrans and where mastertable.tanggal='tanggal yg ditentukan'
saya akan coba delete subdetailtable dgn where
delete from subdetailtable where subdetailtable.notrans=detailtable.notrans and detailtable.notrans=mastertable.notrans and where mastertable.tanggal='tanggal yg ditentukan'
utk tanggal tinggal anda klasifikasikan sendiri berdasarkan bulan or tahun.
mudah2 dapat membantu.
Feel free to call! Free PC-to-PC calls. Low rates on PC-to-Phone. Get Yahoo! Messenger with Voice
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
