We have a Call Sales Report where the address of the customer needs to be on the top showing Address information such as Address1, 2, City, State, PostalCode. I am joining the BAccount with the Address using DefAddressID from the BAccount and AddressID from the Address in the report. I have tried using an Inner, Left, and Right JOIN and keep coming up with “Open server settings” error when using the Address with the BAccount.

Error:

I know that the first image shows the left join, but I have tried the other ones with the same results. The ultimate goal is to just the the address data for each customer that has been visited or called.