Mas Aksan dan rekan milis yang lain, Maksud saya kalau Table 1 (table yang dituju) itu ada ratusan record dimana tidak mungkin untuk membuat sintax sql spt. di bawah juga karena tidak tahu berapa record table 1. Dan juga kita tidak tahu
berapa ratus record yang ada di Table 2 (Table rujukan) . Jadi bisakah ada sintax SQL lain yang tidak memperhitungkan jumlah record ? Terima kasih banyak sebelumnya. (Memang saya tidak terima email jawaban dari Nurhasim.Mungkin masalah di email kantor :)) Salam, Tio "aksankurdin" <[email protected]> Sent by: [email protected] 01/14/2010 02:05 PM Please respond to belajar-access To: [email protected] cc: Subject: [belajar-access] Re: Update Table dari dengan acuan table yang lain Mungkin anda tidak menerima email jawaban dari rekan kita, berikut saya kutip kembali: Re: [belajar-access] Update Table dari dengan acuan table yang lain bisa menggunakan update query, sqlnya spt ini UPDATE Table1 INNER JOIN Table2 ON Table1.nama = Table1.nama SET Table2.nama = [Table2]![kelas] WHERE Table1.nama Is Nul criteria hanya jika memang diperlukan. kl td hapus saja Salam Nurhasim aksan kurdin --- In [email protected], tio.ad...@... wrote: > > Dear Para Pakar Access, > > Adakah teman-teman punya pencerahan untuk pertanyaan di bawah ini ? > > Trims, > Tio > > ----- Forwarded by Tio Adi Bayu Adjie/SSB/PTTU on 01/14/2010 11:53 AM > ----- > > > tio.ad...@... > Sent by: [email protected] > 01/14/2010 07:36 AM > Please respond to belajar-access > > > To: [email protected] > cc: tio.ad...@... > Subject: [belajar-access] Update Table dari dengan acuan table yang lain > > > > > Dear Pakar Access, > > Kalau saya punya Data Table 1 dan table 2 sbb. : > > > > Saya ingin mengupdate Kelas di Table 1 dari Table 2 sehingga menjadi : > > > > Bagaimanakah cara untuk mengupdate table 1 ini ya ? > > Terima kasih atas jawabannya. > > Salam, > Tio > =========================================================================== > > This email is confidential. If you are not the addressee tell the > sender > immediately and destroy this email without using, sending or storing > it. > Emails are not secure and may suffer errors, viruses, delay, > interception > and amendment. The Trakindo Group of Companies do not accept liability > for > damage caused by this email and may monitor email traffic. > > Unless expressly stated, any opinions are the sender's and are not > approved > by the Tiara Marga Trakindo Group of Companies and this email is not > an > offer, solicitation, recommendation or agreement of any kind. > =========================================================================== > > > > =========================================================================== > This email is confidential. If you are not the addressee tell the sender > immediately and destroy this email without using, sending or storing it. > Emails are not secure and may suffer errors, viruses, delay, interception > and amendment. The Trakindo Group of Companies do not accept liability for > damage caused by this email and may monitor email traffic. > Unless expressly stated, any opinions are the sender's and are not approved > by the Tiara Marga Trakindo Group of Companies and this email is not an > offer, solicitation, recommendation or agreement of any kind. > =========================================================================== > =========================================================================== This email is confidential. If you are not the addressee tell the sender immediately and destroy this email without using, sending or storing it. Emails are not secure and may suffer errors, viruses, delay, interception and amendment. The Trakindo Group of Companies do not accept liability for damage caused by this email and may monitor email traffic. Unless expressly stated, any opinions are the sender's and are not approved by the Tiara Marga Trakindo Group of Companies and this email is not an offer, solicitation, recommendation or agreement of any kind. ===========================================================================
