Unity SQL Query for Distibution lists

[climbingfool]

I am trying to run a query that will list all members of a distribution list along with their extension, first and last name.

Here is the query I am trying to build off:
select dtmfaccessid, vw_distributionlist.alias, systemdlistmember.alias, systemdlistmember.displayname
from vw_distributionlist
join systemdlistmember on parentobjectid=systemdlistobjectid
where dtmfaccessid like 90090122
order by systemdlistmember.displayname

I don't think you can query against vw_distribuionlist and vw_subscriber at the same time.

Any ideas?

Thanks
Jason