now has working example using explicit inner join