Hi All

Sorry about the subject title - just trying to be descriptive.

Can anyone advise me on what the SQL syntax would be to update a record within one table with the data selected from another table… e.g.

UPDATE TABLE1 (COL1, COL2, COL3) WHERE COL1 = 7
With the data from TABLE2 (COLA, COLB, COLC) WHERE COLA = 4

It’s the WHERE clauses that baffle me.

As always, your input is much appreciated!

Rit

__________________
Rit
www.designandonline.co.uk
INSPIRE | CREATE | DELIVER

UPDATE Table1 Set Table1.Col1 = Table2.Cola, Table1.Col2 = TAble2.colb, Table1.col3 = Table2.Colc FROM Table1, Table2 WHERE Table2.Cola = 4

Oops, sorry, my previous response is not totally correct. It should be
UPDATE Table1 Set Table1.Col1 = Table2.Cola, Table1.Col2 = TAble2.colb, Table1.col3 = Table2.Colc FROM Table1, Table2 WHERE Table2.Cola = 4 AND Table1.col1 = 7

Wow as simple as that!... Man, you should have seen some of the rocket science I was performing to get there.

Many Thanks

Rit