SELECT ARPayment.amount,ISNULL(LastName, '') + ', ' + ISNULL(FirstName, '') AS PatientName, ISNULL(PatAdd.Address1, '') + ', ' + ISNULL(PatAdd.Address2, '') AS AddLine1, ISNULL(PatAdd.City, '') + ', ' + ISNULL(PatAdd.Prov, '') + ', ' + ISNULL(PatAdd.Postal, '')AS AddLine2, ARPayment.[Date] AS PaymentDate, PatAdd.city, PatAdd.Prov, PatAdd.Postal FROM ARPayment INNER JOIN AR ON (ARPayment.ARID = AR.ID) INNER JOIN Pat ON (AR.BillToPatID = Pat.ID) INNER JOIN PatAdd ON (Pat.ID = PatAdd.PatID) WHERE (ARPayment.[Date] >= '2009-01-01 00:00:00') AND (ARPayment.[Date] < '2010-01-01 00:00:00') AND (Type = 0) AND (Pat.ID IN (26928)and PatAdd.UseForBilling = 1)
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.