Creat temp view templist (TempValue) as select (custProjectStoreNumber & projectinfoprojecttype & city & state) from ttPosition t1, tvProjectInfoTrip t2 where t1.ProjectConstrComplete = t2.ProjectConstrComplete group by custProjectStoreNumber, projectinfoprojecttype,city,state
Select (listof(Tempvalue)) from templist Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Charles Parks Sent: Wednesday, April 22, 2009 11:26 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Listof Distinct 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)
