Need assistance with building a query using the ERD attached. I need to display the patient level demographics with the immunization info. I need to display all data from both tables. The query I have built consistently errors out. Thanks!

syncimmunization

ImmunizationGuid CHAR$(36)$

PatientGuid CHAR $(36)$

VaccineName VARCHAR$(25...$

AdministeredYear INT$(11)$

CvaCode VARCHAR$(100)$

UserGuid CHAR$(36)$

Indexes

patients

PatientID CHAR$(36)$

Gender VARCHAR$(.$

YearOfBirth INT$(11)$

State VARCHAR$(2)$

PracticeID CHAR$(3...$