Find Unequal Types by Comparison

[Kathy Burger]

Column A has transaction ID that is the same for all Debits and Credits, as identified in another column. I need to see where all Debits equal all Credits for all rows where Column A are the same. So, column A identifies the transaction. Column B has a D or a C. Column C has an amount. I need to find where the debits do not equal the credits for items with the same transaction ID.

[computerfox]

What's the query that you built so far?

[RonB]

I need to see where all Debits equal all Credits for all rows where Column A are the same.

I need to find where the debits do not equal the credits for items with the same transaction ID

Answer based on what you asked, not on what you need.

select * from table;

Please clarify your question.

[ck9663]

I got lost somewhere. It would be great if you post some sample data and explain it from there.


~~ CK