Same column name from two tables satisfying two conditions

I need some quick help on SQL. This is basic for most I am sure.

I want to select orderId in both tables merged that satisfies status = 1.

Please find example of the two table tb1 and tb2 here:

tb1

orderId  status
---------------
001     0
003     1
005     1
007     1
...

tb2

orderId  status
----------------
002      1
008      1
004      0

>Solution :

You can use UNION ALL.

Your query would be:

SELECT *
FROM (
   SELECT *
   FROM tb1

   UNION ALL

   SELECT *
   FROM tb2
) a
WHERE STATUS = 1