Find records that do not exist in 2nd table, and also the values mapped against them from first in SQL Server ?

• Yogesh Kumar
• 04-May-2022
• 0

From what you say and show, you want to cross join all table 2 rows to the table 1 rows that don't have a match in table 2. For the lookup you can use NOT EXISTS.

 select t2.id, t1.month, t1.year
from t1 cross join t2
where not exists
(
  select null
  from t2
  where t2.year = t1.year and t2.month = t1.month
);

* Be the first to Make Comment