I found a better thread

http://tek-tips.com/viewthread.cfm?qid=1554047&page=4

>I have:
>
>

>inv
>----
>invno, warehouse
>
>1001    Office
>1002    Showroom
>
>invdetail
>----------
>invno, stockid, check
>
>1001   ABC       0
>1001   XYZ       0
>1002   ABC       0
>

>
>I want to set check=1 for warehouse=Office, something like this:
>
> update invdetail set check=1 where inv.warehouse='Office'
>
>how can I do it and how is the statement in SQL.
>
>Thanks for the help
>
>Jerry