Problem with outer join in query

[Nicholas Scarpinato]

Hello. I have a query which compiles data from two tables, Chargebacks and
Customer Accounts. The problem I'm having is, if a customer has more than one
chargeback for the same dollar amount/bank account number, the query will
only show one chargeback, even though I had a one-to-many join set up to
include all records from the Chargeback table.

Our main problem is that our chargeback file only has two fields we can use
to relate to the customer's account information, the bank account number and
the dollar amount. In order to properly process these transactions to the
customer's accounts, we have to match up the dollars and bank accounts and
add the customer information to the existing chargeback file. At best we are
achieving a 98% success rate.

 

[Tom Ellison]

Dear Nicholas:

Please post the SQL of what you have. It may also be helpful to have some
sample data and the results it gives, plus an explanation of what is wrong.
These are the kind of technical details on which an understanding and
resolution of your problem may be possible.

Tom Ellison