
December 10th, 2003, 04:14 PM
|
|
Junior Member
|
|
Join Date: Dec 2003
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Query one column to populate another
I wonder if you can offer some assistance with this query.
I need to query a table in SQL2000 to read the value in one column and populate a new column with new data. For example:
If Column A = ABC in table Class_001 I need a query statement to populate Column Z with 123
If Column A = XYZ in table Class_001 I need a query statement to populate Column Z with 789
Your help would be much appreciated.
|