Do to growth, I need to change my departments and catagories on many items. Would someone be kind enough to give a query that would do the following:
If dept= A and category = B, then change dept. to C and category to D
Thanks
- posted
17 years ago