We were challenged to create a query that had one student per section per row and also include faculty per section per row. Instead of creating two queries and merging them in excel everyday, we found a "Union" would be the perfect solution. This presentation will show users how to create a union, case statements we used, concatenations, calculation of dates including calculating percentages of dates.