Answer Detail: RE: Why are recursive relationships are bad? How do you resolve them?

GeekInterview.com > Interview Questions > Concepts > Data Modeling

Print |

Question: Why are recursive relationships are bad? How do you resolve them?

July 07, 2005 00:45:58	#2
ritwik roy	Member Since: Visitor Total Comments: N/A
RE: Why are recursive relationships are bad? How do you resolve them?
using the concept of self join may be a solution to this problem. e.g if a table called employees contains three fields like emp_id,name and manager_id and we will have to find out the name of the manager for each employee, then we can use the following code select a.name,b.name from employees a, employees b where a.manager_id=b.emp_id