Where clause in Union

Thank you gbritton, you have pointed me in the right direction, i need to think right and tweak a little to get the results i want. Thanks for your time.

Great! Good luck with the final result!!

Hello gbritton,
I am using rownumber function in that query and in the result i see a null value in the rowNumber column. How do i have the query insert the rownumber even when the value is null? Thanks

I have now resolved my issue, Thanks again.