I have two tables student and stuattendence.
The student table is the parent table.
Here the task is to check whether all the student id's present in the stuattendence table is present in the student table as well.
If not then the id not present in the student table should be collected.
Here i have a query for the same but which does in the work in subqueries.
How do i use any sort of join to to the same task efficiently.
and dbo.stuattendence.stuID not in (select stuID
group by stuID