SELECT *
FROM BPS_Patients
WHERE StatusText = 'Active'
AND InternalID IN (SELECT InternalID FROM patients WHERE mymedicare = 0) -- change 0 to 1 for active
ORDER BY surname, firstname

-- Active Patients marked as registered for MyMedicare