Re: How do you reference custom column names

2007-06-19 Thread Dan Nelson
In the last episode (Jun 19), Scott Haneda said: > SELECT 1+1 as foo, 2 as bar, foo+bar > > This will not work, but I think you can see what I am trying to do. > I need to run a pretty hefty update on a database, and there are some > pretty heavy calculations I will be doing. The result of many

How do you reference custom column names

2007-06-19 Thread Scott Haneda
SELECT 1+1 as foo, 2 as bar, foo+bar This will not work, but I think you can see what I am trying to do. I need to run a pretty hefty update on a database, and there are some pretty heavy calculations I will be doing. The result of many of those, needs to be further used to make updates on other