The output does not contain all of the required columns that we were asked to display
Why dm.* was not selected in order to join more than two tables????. I ran the query in a different way in order to obtain all the requierd three tables:
Actually, we make a cross join between these two tables and the order of the tables does not matter. So we do not need to use aliases, just the name of the tables. When using CROSS JOIN you do not need the ON clause. Actually, JOIN(=INNER JOIN) without ON clause is CROSS JOIN.
Hope this helps.