troubleshooting Question

Update fields within the same table with SQL 2005

Avatar of mattphung
mattphung asked on
Microsoft SQL ServerMicrosoft SQL Server 2005SQL
6 Comments2 Solutions246 ViewsLast Modified:
I have a table with 5 fields (F1,F2,F3,F4,F5)
F1 F2 F3 F4 F5
1   2   3   4   5
6   7   8   9   10

How do I update the table so that field 3 equals to field 4? Example below
F1 F2 F3 F4 F5
1   2   4   4   5
6   7   9   9   10
Join our community to see this answer!
Unlock 2 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros