Maap... moga-moga ini ngebantu...
coba begini:
update product inner join pindahkode on product.kodeproduct =
pindahkode.kodelama set product.kodeproduct = pindahkode.kodebaru
regards,
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
the battle is more intense that it has ever been.
LORD, i need YOU and want YOU so desperately.
please hang on to me.
\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, 06/December/2000 6:24 PM
Subject: [programming] Help. SQL Update melibatkan 2 tabel?
>
> Maap, tanya tentang SQL language,
>
> Ada 2 tabel :
> -Tabel Product berisi field kodeproduct, harga
> - Tabel Pindahkode berisi field kodelama, kodebaru
>
> saya mau mengupdate field kodeproduct pada tabel product, dengan field
> kodebaru pada tabel pindahkode.
> Field kodelama = field kodeproduct.
>
> yang sudah saya lakukan begini tapi semuanya syntax error :
> - update product set kodeproduct = (select kodebaru from product,
> pindahkode where kodeproduct=kodelama)
> - update product, pindahkode set kodeproduct=kodebaru where
> kodelama=kodeproduct
>
> Mohon direvisi, Gimana caranya ?
>
>
> Thanks in advance.
>
> Ahmad Juniar
>
>
>
> --------------------------------------------------------------------------
------
> Utk berhenti langganan, kirim email ke
[EMAIL PROTECTED]
> Informasi arsip di http://www.linux.or.id/milis.php3
> Pengelola dapat dihubungi lewat [EMAIL PROTECTED]
>
--------------------------------------------------------------------------------
Utk berhenti langganan, kirim email ke [EMAIL PROTECTED]
Informasi arsip di http://www.linux.or.id/milis.php3
Pengelola dapat dihubungi lewat [EMAIL PROTECTED]
