Report question

Question: SQL Inner join on select statements