Update using fields from another table

[aj]

Hi,
I'm new to Valentina, I'm wondering is there a way to update one table with
values from another table, this seemed to be pretty standard in sql and
sqlite. The following code doesn't seem to work.

Update T1 Set Field2 = (Select T2.Field2 From T2 WHERE T2.Field1 = T1.Field1
) * 100

Any ideas?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina/attachments/20090206/cd3d2c8b/attachment.html