A group by is absolutely not the correct, proper, appropriate, reasonable, or even successful way to overcome a Cartesian product that has been introduced due to an inability to join two tables that do not have a relationship.

@dextercowley tested the last query and mentioned that it did not fix the duplication problem anyway. So, this is a quick turnaround for the current problem but it re-introduces the duplication problem. 

When do we come to terms with how databases work?