please always identify exactly which table each of your columns comes from
if you don't, you're making us guess, and do extra work trying to figure out what you're doing
, B1.address as InvoiceAddress
from CUSTOMERS as B1
join CUSTOMERS as E1
on E1.invoice_customer = B1.customer_account
and E1.customer_account = '13310'
JOIN Orders as O
on O.account = B1.customer_account
where B1.status = 'D'