Get Multiple Phones For Single Customer without using mutiple inner joins.

Avoid Multiple Inner Joins.sql

SELECT DISTINCT
        STUFF((SELECT DISTINCT ',' + CP.Phone_Nbr
                FROM Customer_Phone CP
                WHERE CM.Cust_Nbr = CP.Cust_Nbr
                FOR XML PATH(''), TYPE)
                .value('.', 'NVARCHAR(MAX)'), 1, 2, '') Phones
FROM Customer_Phone CM where CM.Cust_Nbr = 321