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)

Reply via email to