QUERY HELP||

From: Scott <sivaraman55_at_gmail.com>
Date: 25 Oct 2005 17:33:08 -0700
Message-ID: <1130286788.871200.183290@z14g2000cwz.googlegroups.com>

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. Received on Tue Oct 25 2005 - 19:33:08 CDT