Dear DAN and GRANT

Thank you for the instructions. I followed them, and finally I was successful in retrieving the data I wanted. I have another 2 questions as follows:

1. Can you tell me why I would get an INNER JOIN if I filtered on columns from the OUTER table in the WHERE clause?

2. I am reading the book "Mastering Oracle SQL" (by Sanjay Mishra and Alan Beaulieu), but it does not mention the above issue. Can you suggest me a book that discusses in much detail different issues related to joins?

Thank you