No actually I need to get returned 300 too. But I also want to get returned 100 and 200 each too ( the unite does not match between two tables. ) I am guessing I cannot use unmatched query..
But is there any way that I am able to get the results what I want?
Thank you for help .. and...
wonder if somebody can help
I have two talbes. similar information but the number (count )of data is different. I used Unmatched query to find out discrepancy.. but here is my probelm.
table1 100 100 150 200 300
table2 100 150 200 200
when I run the query, it only shows 300 from table 1...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.