I have Two Table
ID (PK), Name, Address
ID (PK), InfoID (FK for ID from First_Table), BookName
I want to get the count of records that do not have any record in the second table?
select count(*) from first_table f where not exists (select 1 from second_table s where s.infoid = f.id)