Create a query that retrieves all doctors that has treated patients. The query must also display the date and consulations that patients partook in. Your output must resemble the one below.

Create a query to display all patients who made appointments. The query must also display patients treatment and whether the patient has allergies or not. For every patient with no allergies, the word None should be inserted as detailed in the output below.

Vadim 010461 20:15 Treatments Gama Cj treated P, De Waardt on the Fifth of January 2016 for FULL MEDICAL Gama Cj treated P, Mhlanga on the Thirteenth of January 2016 for CONSULTATION Gama Cj treated W, De Waardt on the Thirteenth of February 2016 for CONSULTATION Van Wyk Pj treated J, De Waardt on the Thirteenth of January 2016 for CONSULTATION Gama Cj treated P, De Waardt on the Fifth of January 2016 for INJECTION VOLTAREN 40 Gama Cj treated P, De Waardt on the Fifth of January 2016 for REMOVE STITCHES 6 rows selected. Page Break PATIENT PRESCRIPTION ALLERGY De Waardt, W, 7609097812034 Mhlanga, J , 7809124123456 De Waardt, W , 7609097812034 Mhlanga, J , 7809124123456 De Waardt, W , 7609097812034 De Waardt, W , 7609097812034 Catafast 50mg Imodium 2mg Ultracet Probiflora Probiflora Degoran None None None None None None rour colortod Vadim 010461 20:15 Treatments Gama Cj treated P, De Waardt on the Fifth of January 2016 for FULL MEDICAL Gama Cj treated P, Mhlanga on the Thirteenth of January 2016 for CONSULTATION Gama Cj treated W, De Waardt on the Thirteenth of February 2016 for CONSULTATION Van Wyk Pj treated J, De Waardt on the Thirteenth of January 2016 for CONSULTATION Gama Cj treated P, De Waardt on the Fifth of January 2016 for INJECTION VOLTAREN 40 Gama Cj treated P, De Waardt on the Fifth of January 2016 for REMOVE STITCHES 6 rows selected. Page Break PATIENT PRESCRIPTION ALLERGY De Waardt, W, 7609097812034 Mhlanga, J , 7809124123456 De Waardt, W , 7609097812034 Mhlanga, J , 7809124123456 De Waardt, W , 7609097812034 De Waardt, W , 7609097812034 Catafast 50mg Imodium 2mg Ultracet Probiflora Probiflora Degoran None None None None None None rour colortod