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