This query will provide a list of patrons and which mobile carriers they’re using. You can modify the CarrierIDs as needed to get specific carrier data.
SELECT
pr.PatronFullName AS [Patron Name],
pr.PatronID,
p.Barcode,
mpc1.CarrierName AS [Phone 1 Carrier],
mpc2.CarrierName AS [Phone 2 Carrier],
mpc3.CarrierName AS [Phone 3 Carrier]
FROM
Polaris.Polaris.PatronRegistration pr WITH (NOLOCK)
INNER JOIN
Polaris.Polaris.Patrons p WITH (NOLOCK)
ON (p.PatronID = pr.PatronID)
LEFT JOIN
Polaris.Polaris.SA_MobilePhoneCarriers mpc1 WITH (NOLOCK)
ON (mpc1.CarrierID = pr.Phone1CarrierID)
LEFT JOIN
Polaris.Polaris.SA_MobilePhoneCarriers mpc2 WITH (NOLOCK)
ON (mpc2.CarrierID = pr.Phone2CarrierID)
LEFT JOIN
Polaris.Polaris.SA_MobilePhoneCarriers mpc3 WITH (NOLOCK)
ON (mpc3.CarrierID = pr.Phone3CarrierID)
-- Modify these CarrierIDs as needed. You'll probably want them to match throughout.
WHERE (
pr.Phone1CarrierID IN (1,45,32)
OR
pr.Phone2CarrierID IN (1,4,32)
OR
pr.Phone3CarrierID IN (1,4,32))