Creating a column using two separate columns from different query.

Hello,

I have been trying to figure out how I can create a column that are based off of he date from 2 seperate columns that come from 2 seperate querys.

Example 

 Query/table 1                              Query /table 2                    

ID #                                             ID # a2

inital test                                      final test 2

columm x                                     columm y

Desired result (this table is visualizaton table created from multiple Tables )

ID #                     inital test                           Final test                                Status 

123                      pass                                   "blank"                                 In-process

124                      "blank"                               "blank"                                 "blank"                                          

125                      pass                                     pass                                     Ready

I need to create column in a table that says 

If  ID number passes final test it is ready if ID passes inital but final is blank than in process. 

These two query are link to a third quarey by ID# so it did not alow me to creat a realtionship to each other.

Both Inital test and Final test are created based on other colmns with in their query/tables. 

Can someone help with this?