SELECT  CE.ID ,
        CA.CustomerID,
	CA.PostalCode
FROM    DBXN.CommunicationEntry CE
        LEFT OUTER JOIN ( SELECT    A.ID ,
                                    CA.CustomerID ,
				    A.PostalCode,
                                    A.EnglishAddressLine1
                          FROM      DBXN.Customer_Address AS CA
                                    INNER JOIN DBXN.Address AS A ON CA.AddressID = A.ID
                        ) AS CA ON CE.CustomerID = CA.CustomerID
WHERE   CE.ID = 6298103

SELECT  CE.ID ,
        CA.CustomerID,
	CA.PostalCode,
	CA.EnglishAddressLine1
FROM    DBXN.CommunicationEntry CE
        LEFT OUTER JOIN ( SELECT    A.ID ,
                                    CA.CustomerID ,
					A.PostalCode,
                                    A.EnglishAddressLine1
                          FROM      DBXN.Customer_Address AS CA
                                    INNER JOIN DBXN.Address AS A ON CA.AddressID = A.ID
                        ) AS CA ON CE.CustomerID = CA.CustomerID
WHERE   CE.ID = 6298103