Master table all data and transaction table status only

siva balan

6y838SQL

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramachandran M6y ago
Accepted answer
Here is my output
0
Ramachandran M6y ago
Hi Siva,

Kindly give more info to analyse.
0
siva balan6y ago
Current query also bring matching id data only
0
Ramachandran M6y ago
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.
0
siva balan6y ago
Sorry , its didn't workout for my condition..
0
Ramachandran M6y ago
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
0