update statment

  • Thread starter Thread starter Nicky
  • Start date Start date
N

Nicky

Is there a way to do that with inner join??
-----Original Message-----
your syntax for update query is wrong. you cant use from
in update query.

the syntax is: update <table name> set <field name>=
<value> where <condetion>

you can use a select statement as a subquery in the where
part. ensure you use proper braces if you do that.

your query should look some what like that.

Update table1
Set field= (select table2.field
From table1 Inner join table2 on ....
inner join table3 on....

also try using query wizard if you find creating update
query tedious.
.
 
Back
Top