I've done inserts but never had to do it w/ updates. According to the documentation, the syntax should be something like this:
Update table1 Set table1.col1 = table2.col3 >From table1, table2 where table2.id = table1.id I keep the "SQL Server Books On-line" documentation installed on my local machine. It is of great help when I'm doing complicated SQL. You can get it off the web if uyou don't have an install CD handy: <http://www.microsoft.com/downloads/details.aspx?FamilyID=A6F79CB1-A420-445F-8A4B-BD77A7DA194B&displaylang=en> (Watch the line wrap ). I found your answer in "UPDATE, UPDATE (described)" At 07:42 PM 11/27/2006, you wrote: >Is this possible, I thought I had once this once before but I don't seem to >be able to get it to work:-( > >Update table1 >Set table1.col1 = table2.col3 >Select table.col1, table2, col3 >From table2 inner join table1 on table2.id = table1.id > >And yes before I forget this is MS SQL Server 2000:-) -- Jeffry Houser, Software Developer, Writer, Songwriter, Recording Engineer AIM: Reboog711 | Phone: 1-203-379-0773 -- My Company: <http://www.dot-com-it.com> My Books: <http://www.instantcoldfusion.com> My Recording Studio: <http://www.fcfstudios.com> Connecticut Macromedia User Group: <http://www.ctmug.com> Now Blogging at <http://www.jeffryhouser.com> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2644 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
