Correlated Sub Query

 Correlated Sub Query

In a Correlated Subquery the inner query is dependent on the Outer Query. You cannot run the inner query independently.

 Non Correlated Sub Query

In a Non Correlated Subquery the inner query is NOT dependent on the Outer Query. You cannot run the inner query independently.

https://youtu.be/Ra3ISwvcFlM?si=ENQPwqmxdqBBnUwp