lines from wiki
the child and parent table may, in fact, be the same table, i.e. the foreign key refers back to the same table. Such a foreign key is known in SQL:2003 as a self-referencing or recursive foreign key. ... A table may have multiple foreign keys, and each foreign key can have a different parent table
64.3k questions
77.9k answers
244k comments
80.0k users