Joins for a compound view

What is the best way to implement join behaviour for a compound views?