from blob b, ancestors a
WHERE b.rid=a.rid
</pre></nowiki>


<h2>Recursion Example</h2>

See also: [http://www.sqlite.org/draft/lang_with.html]
Adapted from a sqlite mailing list post by Petite Abeille on 20140203, not directly applicable to fossil but which is an interesting example nonetheless and
which can certainly be used as a model for generating fossil-related data:

The following is adapted from a sqlite mailing list post by Petite Abeille on 20140203, not directly applicable to fossil but which is an interesting example nonetheless and which can certainly be used as a model for generating fossil-related data:

<nowiki><pre>
with
DataSet(node,parent)
as
(
  select  'A', null union all