Thank you Jose. I will look into this. On Sunday, July 22, 2012 7:21:29 PM UTC-4, Jose wrote: > > > > El domingo, 22 de julio de 2012 17:39:29 UTC-3, Cliff Kachinske escribió: >> >> I have a need to provide an index of both people and organizations on the >> same view. >> >> In raw sql it would be something like this >> >> SELECT name FROM organizations WHERE something >> UNION >> SELECT CONCAT(first_name, last_name) AS name FROM people WHERE something >> ORDER BY name; >> >> DAL doesn't support CONCAT, and I don't want to mess with raw sql if I >> can avoid it. >> >> You can use virtualfield [0] >> > > Jose > > [0] http://www.web2py.com/books/default/chapter/29/6 >
--
