Loop: loop is a closed path (relation) that exists among 3 (or) more tables. For example, if we have '3' tables T1, T2, T3 then, a loop exists among these tables only when we create joins in the following fashion: Loop: T1 ---> T2 ---> T3 ---> T1To resolve the above problem, we have to create a shortcut (or) Alias to the Table T1. No Loop: T1 ---> T2 ---> T3 ---> Alias (or) Shortcut of T1
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!