mudah2an bisa
delete from detailTabel where NOTRANS in (Select NOTRANS from MasterTable where month(TANGGAL) = '04')
delete from SubdetailTabel where NOTRANS in (Select NOTRANS from Mastertable where year(TANGGAL) = '2004')
klo mau delete 22nya mungkin tinggal di UNION Ajah.
"A. Numairullah" <[EMAIL PROTECTED]> wrote:
Dear All,
Sy punya tabel di SQL Server sbb :
1. Nama Tabel : MasterTabel
Field²nya : NOTRANS,TANGGAL,KODECUST
-------
2. Nama Tabel : DetailTabel
Field²nya : NOTRANS,KODEBARANG,QTY
------- ----------
3. Nama Tabel : SubDetailTabel
Field²nya : NOTRANS,KODEBARANG,NOPACK,SIZE
------- ----------
Sy mau hapus record² di Table No.2 dan/atau Table No.3
dengan klasifikasi BULAN dan TAHUN tertentu,
Script SQL nya bagaimana ya D'All ? Bantu-in Donk....
Thank's B4
B'Rgds,
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Blab-away for as little as 1¢/min. Make PC-to-Phone Calls using 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.
