Normaly I am reluctant to supply code, I prefer to give hints only - as David did and encourage you to do some research but as you posted some code you were abviously willing to learn. Look into UNION and UNION ALL as suggested by Jorgen.
Never underestimate the power of human stupidity RAH