RDBMS 10 /15 - IN operator and Query nesting
This Video covers a slightly complex query with multiple or filters and the concept of query nesting with example that will help you in collecting data from various tables that may or may not be related into one desirable format.