• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 322
  • Last Modified:

Find Diferences Balances

I have 3 tables where the account numbers are the same and but there are accounts in the three tables that some of the balances do not match and Like to find the account where the balances don't match...

the ID is the same on all three tables
the Balances in same accounts Different

I tried the compare query however it does not work...

any assistance is appreciated please...
1 Solution
Rey Obrero (Capricorn1)Commented:
try this query

select T.ID,T.Balances
select id,balances from table1
union all
select id,balances from table2
union all
select id,balances from table3
) as T
group by T.ID,T.Balances
order by 1
Jeffrey CoachmanMIS LiasonCommented:
My guess is that capricorn1 may have your solution here, ...
So reply to his post first.

I am not as good with sub queries, and I am not quite sure of your data, ...so here is something that uses two queries to get what I think you want...
see: query5
...to see the "unmatched" records
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now