Multi lingual translations for Queries with Unions ... it shouldn't be this hard!

I created a query to be used in a pagelet that would show a users training taken in the current year.  At first I used the training table data, but when it came time to get the Canadian French translation, I found that this table did not have a related language table.  For MISC courses, we needed the description from training, but for all other courses we need the course description from the couse_tbl, which has a related language table.  Perfect.  However, in order to get the correct description into the Query, we needed to use a UNION to get