Master table all data and transaction table status only

Question

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...

Ramachandran M · Accepted Answer

Here is my output

Ramachandran M · Answer

Hi Siva,   Kindly give more info to analyse.

siva balan · Answer

Current query also bring matching id data only

Ramachandran M · Answer

i was created same structure table as you mentioned and execute the query. it was return result as your output result.   kindly give more info to analyse further.

siva balan · Answer

Sorry , its didn't workout for my condition..

Ramachandran M · Answer

TRY THIS
SELECT T1.CATEGORYID,T1.CATEGORYNAME,CASE WHEN T2.[STATUS] IS NULL THEN 'OPEN' ELSE T2.[STATUS] END 'STATUS' FROM TABLE1 T1
LEFT JOIN TABLE2 T2 ON T1.CATEGORYID = T2.CATEGORYID