Confusion with a query

simkaur,

Have a left join with patient acoount - so irrespective of whether matching rows exist in patient_account or not, the rest of the setup wont be affected :)

something like:

select p.col_name1,m.col_name2
from patient p
inner join message m on p.patient_GUID=m.patient_GUID
left join patientaccount pa on p.patient_GUID=pa.patient_GUID

---

Thanks,

Jay

<If the post was helpful mark as 'Helpful' and if the post answered your query, mark as 'Answered'>