Matthew: What an intriguing idea! I just had to try this out. I created a temp table based on a perm table I had, and tried your update command to update the temp based on the perm. I got a "syntax error". So it didn't work for me. It would be pretty cool if you could use the update in that fashion, where it would be smart enough to update matching column names.
Karen > 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! > >
