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]_
<mailto:belajar-access%40yahoogroups.com>, 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]_
<mailto:belajar-access%40yahoogroups.com>
> 01/14/2010 02:05 PM
> Please respond to belajar-access
>
>
> To: [email protected]_
<mailto:belajar-access%40yahoogroups.com>
> 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]_
<mailto:belajar-access%40yahoogroups.com>, 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]_
<mailto:belajar-access%40yahoogroups.com>
> > 01/14/2010 07:36 AM
> > Please respond to belajar-access
> >
> >
> > To: [email protected]_
<mailto:belajar-access%40yahoogroups.com>
> > 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.
===========================================================================
