Appending queries

You are a newly hired data analyst for the Yale New Haven Health System Emergency Department. Your boss has provided you with two data files to be combined. One lists all emergency visits where patients were admitted for further care, and the other lists visits where patients were discharged to their home residences.

Your task will be to combine the datasets to make a master file of all visits for further analysis.