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. > =========================================================================== >
