SyntaxFix
Write A Post
Hire A Developer
Questions
You can use IN operator as below
select * from dbo.books where isbn IN (select isbn from dbo.lending where lended_date between @fdate and @tdate)