Re: [SQL] Need some help with crafting a query to do major update

On Wed, 18 Feb 2004, Sean Shanny wrote: > To all, > > This is part of a data warehouse. Made the mistake of using a natural > key in one of the fact tables. :-( The f_test_pageviews is a simple > testing table while I work this out. The real table has an identical > schema. > > I have built a

[SQL] Need some help with crafting a query to do major update

To all, This is part of a data warehouse. Made the mistake of using a natural key in one of the fact tables. :-( The f_test_pageviews is a simple testing table while I work this out. The real table has an identical schema. I have built a mapping table, d_user, to allow the replacement of t