Mas Aksan dan rekan milis lain, OK-lah kalau begitu :)).
Adakah cara lain untuk mensiasati kejadian spt. kasus yang saya maksudkan ? Sebelumnya saya sudah pakai cara query union dan query append ternyata itu lebih rumit karena banyaknya table yang di gabung. Adakah cara lain sbg alternatifnya untuk menyelesaikan masalah ini. Terima kasih sebelumnya. Salam, Tio "aksankurdin" <[email protected]> Sent by: [email protected] 01/14/2010 02:38 PM Please respond to belajar-access To: [email protected] cc: Subject: [belajar-access] Re: Update Table dari dengan acuan table yang lain Syntak SQL bekerja pada level tabel, bukan record, kecuali jika disebutkan kriteria di dalamnya. select * from customer akan memberikan semua data customer, misalnya ada 500, maka 500 yang diberikan oleh sintak ini. update from customer set nama='tio' maka semua 500 record akan di update field nama menjadi 'tio' update from customer set nama='tio' where nama='aksan' maka hanya record yang namanya 'aksan' saja yang akan diproses sql update tersebut. UPDATE Table1 INNER JOIN Table2 ON Table1.nama = Table1.nama SET Table1.kelas = Table2.kelas WHERE Table1.nama Is Null berarti semua field kelas di table1 yang null (kosong) akan diupdate sesuai dengan field kelas di table2, yang namanya cocok / sesuai antara table1 dan table2. Aksan Kurdin --- In [email protected], tio.ad...@... wrote: > > 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" <aksan.kur...@...> > 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.adjie@ 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.adjie@ > > Sent by: [email protected] > > 01/14/2010 07:36 AM > > Please respond to belajar-access > > > > > > To: [email protected] > > cc: tio.adjie@ > > 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. > =========================================================================== > =========================================================================== 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. ===========================================================================
