Rob Kinyon wrote: > DBIx::Class views are the way to go. Look in the ResultSource documentation. Thanks for the confirmation. It turns out what I didn't realize was how to apply a SQL UNION in that context. So it's working now. Thanks, Dave