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. Does anyone have any ideas? Any opinions gratefully accepted. Thanks, Cliff Kachinske --
