Home Forums Discussions General Discussion Report to Include Patient Address

This should get your started. Reach out if you require further assistance.

SELECT [First] as FirstName, [Last] as LastName, PatientAddress as AddressOne, PatientAddress2 as AddressTwo, Demographics.City, State, PostalCode
FROM Demographics INNER JOIN ListPayors ON Demographics.PatientID = ListPayors.PatientID
INNER JOIN PayorsEdited ON ListPayors.PayorsID = PayorsEdited.PayorsID
WHERE PayorsEdited.PayorName = 'Your Medicare Name Here'

JamesNT