Doubt abou scope

Hello

I need create a scope with inner join, using two tables. How Can I do this?