I have what should be a simple question. (BTW I am not facile in SQL)

In the following query there are times when the last table
(SedationQiSub3) has no entry for a patient. Someone didn't type in a
memo. If that patient has no entry for the memo, the query will not
retrieve that patient at all.
Is there a way to get the patient and the rest of the data if there is
no record in the table which contains the memo?
Thanks,

Craig

Query
ANSWER: :Ktables:sedationQIPeer2.db

:Ktables:Bioinfo.DB | Status | Year |
Unique# |

:Ktables:Bioinfo.DB | HospitalNumber | FirstName | LastName |
Birthdate |

:Ktables:SedationQImain.DB | Status | Year | Unique# |
DateField | #forToday | Flag |

:Ktables:SedationQIsupplimental.DB | Status | Year | Unique# |
#ForToday |

:Ktables:SedationQIsupplimental.DB | MajorAdverseOutcome | SedationDOC

:Ktables:SedationQIsupplimental.DB | SedationDocAlsoProcDoc |
ASAStatus | ASAeStatus |

:Ktables:SedationQIProblems.db | Status | Year | Unique# | #ForToday

:Ktables:SedationQIsub3.DB | Status | Year | Unique# | #ForToday |
Memo |

EndQuery