Kalau pake MSSQL coba syntax ini:
UPDATE InventTableModule
SET TaxItem = 'LOC PPN'
WHERE
(ItemId IN (SELECT ItemId
FROM dbo.InventTable
WHERE (ItemGroupId = 'SUI')))
Karena data yang dimaksud tidak ada di InventTableModule maka hasilnya null,
kalau ingin coba berhasil atau tidak coba ganti dengan yg lain, misal STI.
Good luck
=D
On 9/22/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hello mitek,
>
> Saya punya tabel
>
> InventTable :
> ItemGroupId ItemId
> STI 01.01.00001.MI
> STI 01.01.00002.MI
> SUI 02.01.00006.TTK
> SUI 02.01.00006.UNI
> MTP 04.03.00001.PP
>
> InventTableModule :
> ItemId ModuleType TaxItem
> 01.01.00001.MI 0
> 01.01.00001.MI 1
> 01.01.00001.MI 2
> 01.01.00002.MI 0
> 01.01.00002.MI 1
> 01.01.00002.MI 2
> 04.03.00001.PP 0
> 04.03.00001.PP 1
> 04.03.00001.PP 2
>
> Saya ingin update Field TaxItem di tabel InventTableModule dgn isian
> 'LOC PPN' dgn kriteria ItemGroupId di tabel InventTable = SUI.
>
> Kira-kira gimana ya script update statementnya ya ? :D
>
> Saya udah utak-atik kira2 spt ini :
> update InventTableModule
> set TaxItemGroupId
> where select ItemGroupId from InventTable where rtrim(ItemGroupId) =
> 'SUI'
>
> Error,hasilnya....
>
> Terima kasih sebelumnya bagi yg mau menjawab :D
>
> --
> Best regards,
> setiaji mailto:[EMAIL PROTECTED]<setiaji_kurniawan%40yahoo.com.sg>
>
>
>
[Non-text portions of this message have been removed]
================> HAPUS IKLAN DIATAS DAN FOOTER INI JIKA ME-REPLY
<================
Posting : [email protected]
Archive : http://www.mail-archive.com/[email protected]/
www.mitek.unibraw.ac.id || himamitek.brawijaya.ac.id
************************************************************************************
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/mitek/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/mitek/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
