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
