• Thanks Alvin and luiz.

    Did you refer that I need to union with another table?

    The single query worked fine when I executed. Each one has the data I want.

    I just want to combine those two.

    Thank you,.