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
If it's not broken, fix it until it is.
My Blog