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