SELECT FirstName,MiddleName,LastName,Company,TaxExempt,AddressTitle,AddressLine1,AddressLine2,City,[State],ZipCode,Country,PhoneNumber,EmailID,
o.OrderNumber,o.PONumber FROM CustomerAddresses ca join Orders o on ca.CustomerID=o.CustomerID ,Count(*)As Count where AddressTitle='Billing'
Group by FirstName,MiddleName,LastName,Company,TaxExempt,AddressTitle,AddressLine1,AddressLine2,City,[State],ZipCode,Country,PhoneNumber,EmailID,
o.OrderNumber,o.PONumber FROM CustomerAddresses ca join Orders o on ca.CustomerID=o.CustomerID Having Count(*)>1