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.


Reply via email to