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.
