Answer:
In nested joins, for each tuple in the outer join relation, the system scans the entire inner-join relation and appends any tuples that match the join-condition to the result set.
| Previous Question | Next Question |
| What is a self join in SQL Server? | What is Merge join? |