Confusion with a query

What you need is a left join.

select * from Patient
join Message on Patient.GUID = Message.PatientGUID
left join PatientAccount PA
On PatientAccount.someid=Patient.someid 
 where Message.GUID = Data

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.