I have two tables one is master table a another  table is transaction table ,I want the output like master table all data and transaction table status only
Table a:
CategoryId    CategoryName
   1                        C#
   2                     Java
   3                      Angular
   4                        React
  5                         C++
Table b:
CategoryId          Status
      1                     Closed
      3                     Closed
OutPut: 
CategoryId     CategoryName   Status
  1                                                C#                    Closed
   2                                          Java                    Open
   3                                           Angular               Closed
   4                        React                  Open
  5                         C++                    Open
 
thanks you guys, I am waiting for your replys...