Re: QUERY HELP||

Scott wrote:
> Hi All
> I have four tables tableA, tableB, tableC and tableD which has the
> structure shown below:
>
> TableA
>
> colIDA
> ColStatusA
>
> TableB
>
> colIDB
> ColStatusB
>
>
> TableC
>
> colIDC
> ColStatusC
>
>
> TableD
>
> colIDD
> ColStatusD
>
> I want to write a update query in a transaction that updates the
> status columns in all the tables where colIDA = colIDB = colIDC =
> colIDD. The colIDs values will be looped over. How can I best
> accomplish this.
>
> Thanks for help,
>
> Scotty.

By asking your instructor for help after class.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)