Is there an issue with just replacing the join with the inner query that you call temp with one containing all the fields required into the select and also the...