Sorry. 10 minutes later I figure it out by just changing a small thing in Shailaja's query. Here is what I came up with if anybody else needs to do something similar.
Assumptions: $ArrayName is the variable for the source filer.
SELECT
array.name AS 'Array Name',
array.ip AS 'Array IP'
FROM
storage.array
WHERE
'${ArrayName}' = 'sourcebase.x.x.com'
AND array.name = 'destbase.x.x.com'
OR
'${ArrayName}' = 'othersourcebase.x.x.com'
AND array.name = 'otherdestbase.x.x.com'