Hi Anto,
Bisa di coba cara begini enggak ya? 1. Buat Query2 dengan select Query: SELECT [KDCAB] & [KDCUS] AS DEL_ID FROM TJUAL 2. Buat Query3 dengan Delete Query: DELETE DEL_ID FROM Query2 WHERE DEL_ID In (SELECT [KDCAB] & [KDCUS] FROM TDEL) Salam, ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of anto Sent: Tuesday, September 29, 2009 4:16 PM To: [email protected] Subject: [belajar-access] Delete baris di table jual (TJUAl) berdasarkan table delet (TDEL) To. User Access & Expert Selamat Hari Raya Idul Fitri; Semoga Kita semua menjadi orang yang kembali Fitrah dan senantiasa berada dalam lindungan-Nya. Langsung aja.. mungkin ada yang bisa share ke saya bagaimana caranya mendelete 1 baris di TJUAL berdasarkan data di TDEL.. TJUAL KDCAB KDCUS JAN FEB MAR A0 A001 500 500 500 B0 V001 500 500 500 A0 A003 500 500 500 C0 A001 500 500 500 D0 A001 500 500 500 A0 A002 500 500 500 TDEL KDCAB KDCUS A0 A001 B0 V001 C0 A001 Terima kasih atas bantuan dan pencerahan-nya Anto ----------------------------------------- ---------------------------------------------------------- This transmission is CONFIDENTIAL and the information is intended only for the use of the individual or entity to whom it is addressed. If you are not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any use, dissemination, distribution or copying of this communication is STRICTLY PROHIBITED. If you have received the transmission in error, please immediately notify us by email and/or telephone, and delete the transmission and any attachments from your mailbox. Thank you.
