What would be the expected output if your results looked like this and why?
The Second SQL Statement Result was like below one,
ID NAME HOURS
1 AAA 20
2 BBB 30
3 CCC 0
4 DDD 0
After writing the The above UNION Statement i get like below one
ID NAME HOURS
1 AAA 10
2 BBB 10
3 CCC 0
4 DDD 0
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/