Charlie, Not sure if this will work, but break it in two: CREATE TEMP VIEW DistinctStuff (BunchofColumns) AS SELECT + DISTINCT (custProjectStoreNumber & projectinfoprojecttype & city & state) + FROM ttPosition t1, tvProjectInfoTrip t2 WHERE (t1.ProjectConstrComplete = t2.ProjectConstrComplete)
SELECT LISTOF(BunchOfColumns) FROM distinctStuff Bill On Wed, Apr 22, 2009 at 9:25 AM, Charles Parks <[email protected]> wrote: > Is there a way to get a listof of distinct values over a multiple > columns? > > When I try this > select listof (distinct custProjectStoreNumber & projectinfoprojecttype & > city & state) from ttPosition t1, tvProjectInfoTrip t2 where > t1.ProjectConstrComplete = t2.ProjectConstrComplete > I get this error > -ERROR- Column or variable listof not found (2515) >
