I need a clarification from below query.
SELECT API.API, [T SCREEN].*, [B SCREEN].*
FROM (API LEFT JOIN [T SCREEN] ON API.API = [T SCREEN].API) LEFT JOIN [B SCREEN] ON API.API = [B SCREEN].API;
The results will display all records from both B screen and Tscreen. Like 3 + 3 =6.
But i need only b screen records along with t screen records with satisfy the api.
The records shown belo
B 1 1 1 1
T 2 2 2 2
I need below
1 1 1 1 2 2 2 2
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)