I have taken the if clause out of the query. There is the Inner Join clause, but you don't specify the columns on which to join TrainingName and the subquery.  So,...