siva balan

siva balan

  • NA
  • 92
  • 8k

Master table all data and transaction table status only

Dec 5 2019 11:36 PM
    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... 
 

Answers (6)