Update query will only allow me to use one table

[handlebars]

I am trying to perform an update query on a table from a field in a related table.

However, when I go to design this query, it will only allow me to use one table.

Is there any other way around this? Im sure its possible like using MS Access, but cannot work out how!

Any help would be appreciated.

Andrew

 

[SQLSister]

Does this help:

UPDATE Table1
SET Field1 = Table2.Field2*100
FROM Table1 join Table2
ON Table1.IDField = Table2.IDField
WHERE Table2.Field3 = 'sometext' and table1. Field1 is null

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief