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)
With the data from TABLE2 (COLa,)
WHERE TABLE1 COL2 = TABLE2 (COLc,) or TABLE2 (COLb,) or TABLE2 (COLc,)


Thank you Nigel Cross

Something like:


UPDATE TABLE1 (COL1)
Select TABLE2.COLa from TABLE2
WHERE TABLE1.COL2 = TABLE2 .COLc.
or TABLE1.COL2 = TABLE2.COLb
or TABLE1.COL2 = TABLE2. COLc


I would also suggest checking the help file for more examples.

Thanks HiTec I give it a try.

Thank for your in put.

Thanks Hitec, this worked just great.:)