SELECT     dbo.ContactBase.New_Title, dbo.Contact.FirstName, dbo.Contact.LastName, dbo.Contact.MiddleName, 
		   dbo.Contact.MobilePhone, dbo.CustomerAddress.Telephone1, dbo.Contact.BirthDate, dbo.Contact.GenderCode, 
		   dbo.Contact.FamilyStatus, dbo.CustomerAddress.Line1, dbo.CustomerAddress.Line2, dbo.CustomerAddress.Line3, 
           dbo.CustomerAddress.City, dbo.CustomerAddress.County, dbo.CustomerAddress.PostalCode, 
           dbo.CustomerAddress.Country, dbo.Contact.ContactId

FROM       dbo.CustomerAddress INNER JOIN
                      dbo.Contact INNER JOIN
                      dbo.ContactBase ON dbo.Contact.ContactId = dbo.ContactBase.ContactId ON 
                      dbo.CustomerAddress.ParentId = dbo.Contact.ContactId
WHERE     (dbo.CustomerAddress.AddressNumber = 1)