How to trace the chain in the database?

Question

SQL

There are three fields in the table: | ID| ID_previous| Data|
In ID_previous, as you might guess, contains IDthe previous element of the chain.
How to use SQL to IDfind the last element of the chain by the first element?

Answer 1

a recursive query or a cycle
, in principle, is directly according to the manual of its subd in the recursive section