Re: [belajar-access] Update Table dari dengan acuan table yang lain

Wed, 13 Jan 2010 18:07:01 -0800

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


--- On Wed, 1/13/10, [email protected] <[email protected]> wrote:

From: [email protected] <[email protected]>
Subject: [belajar-access] Update Table dari dengan acuan table yang lain
To: [email protected]
Cc: [email protected]
Date: Wednesday, January 13, 2010, 4:36 PM

 


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

Kirim email ke