Views are only useful if you will repeatedly do the same query on the same view. In this case, it sounds like the OP was saying for every pair of tables like th

Views are only useful if you will repeatedly do the same query on the same view. In this case, it sounds like the OP was saying for every pair of tables like this you have to do this big query. Still, views are free aren't they? Might as well create a view even if it is just for one query.