Trying to use a subquery to find two things from two different tables
I want to find the book code and book title for each book found in branch number 2 and written by author 20. 
the book code and title are found in the "book" table
branch number is found in the 'branch' table 
the "author" table has the author number
theres also a table called 'inventory' that has book code and branch number

any help would be greatful!

Trying to use a subquery to find two things from two different tables
===

I want to find the book code and book title for each book found in branch number 2 and written by author 20. 
the book code and title are found in the "book" table
branch number is found in the 'branch' table 
the "author" table has the author number
theres also a table called 'inventory' that has book code and branch number

any help would be greatful!
