Hi Matthew, If you are basically trying to copy a row from one table to another, you could first delete the row from table 1, then insert into table 1 using the select * from table 2.
Bernie Lis ----- Original Message ----- From: Matthew Burke To: RBASE-L Mailing List Sent: Tuesday, April 20, 2010 6:47 PM Subject: [RBASE-L] - Trying to keep a large UPDATE simple as possible Hello all, I think most of you can see what I am *trying* to do just by looking at the original command I was unsuccessful with. So here it is. J UPDATE Table1 SET T1.* = T2.* FROM Table1 T1, Table2 T2 WHERE T1.ID = T2.ID Can I keep an UPDATE command this simple by simply changing a few items around? I'm trying to avoid. UPDATE Table1 SET T1.Col1 = T2.Col1, T1.Col2 = T2.Col2. multiplied by 300, if it is at all possible. Thanks in advance! Matthew Burke Pioneer Bank - IT Department Computer Systems Technician 575-627-4415 Office 575-624-3389 E-Fax [email protected] 3000 N Main Roswell NM 88201
