Dick, Project is an R:BASE command, not straight SQL. Use it with a view to change the column name:
CREATE TEMP VIEW tcolorsview AS SELECT Mfg, Style, Prodcolor AS RealColor where StyleNo = '2297' PROJECT TEMP tcolor from tcolorsview Bill On Tue, Sep 21, 2010 at 11:11 AM, Dick Fey <[email protected]> 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. > > >
