Consider the following question: We have 3 tables,
1. Theatre ( theatre_Id, thatre_name )
2. ShowTime ( showTimeId, theatre_Id, movie_id )
3. Movies ( movie_id, movie_name )
Now same movie name can also have different movieId's sort of dependent on the reel.
Eg: [1, HarryPotter], [2, HarryPotter], [3, Pirates of Carr]
Now we need to find movie name which has showtime on all theatre locations ? Is it nested correlated query ?
See Question&Answers more detail:os