10 digit dialing query

Version 1
    This document was generated from CDN thread

    Created by: Jacob Henson on 11-01-2012 03:15:35 PM
    Goal:  I want to be
    able to generate a list of users and their 10 digit phone number using AXL.
     
    I am able to query the enduser table to get their extension.  But how do I tie that information to a transformation
    to figure out the 10 digit number.
     
    In an ideal result set I would get back 3 columns User, extension,
    and transformation.
    Userid   extension            transformation

    user1     83245                   1555555XXXX

    user2     89804                   1555555XXXX

     
    If anyone could tell me the right table combination, I would be able to write the query.  Thanks for any help.