A union and a join are similar in that they are both ways of combining two tables to form another table. However, they combine them in two very different ways. Exactly how are they different? Please give and discuss an application of each providing detailed examples. What is the difference between a Join and a Subquery? Provide a coding example of both a Join and a Subquery that will accomplish the same task.