Thanks Bill and Albert:
Finally got it to work using the rename column command.
I did not know if I could append a view to a table, which was my
ultimate goal.
Anyhow, got it. Thanks
Dick
On 9/21/2010 10:38 AM, Albert Berry wrote:
Dick, try this.
Project temp tcolors from colors using Mfg, Style, Prodcolor where
StyleNo = '2297'
RENAME COLUMN ProdColor to RealColor IN tColors
Have you considered using a view instead of the temp table?
CREATE VIEW vwColors (Mfg, Style, RealColor) +
AS SELECT Mfg, Style, ProdColor +
FROM Colors where StyleNo = '2297'
Albert
On 21/09/2010 9:11 AM, Dick Fey wrote:
I can do a select and change a column name using AS.
When I try to project a temp table using the same syntax, I get a
syntax error.
ie:
Project temp tcolors from colors using Mfg, Style, Prodcolor AS
RealColor where StyleNo = '2297'
Can you not do that?
Dick Fey
Carpet Broker Inc.
