On 10/12/2014 4:03 PM, Paul Sanderson wrote:
Is this possible just using SQL select type statements?
With sufficiently recent SQLite version, you can do something like this (untested):
with recursive path as ( select id, previousid, location from mytable where id=6 union all select id, previousid, location from path join mytable on (path.previousid = mytable.id) ) select * from path; -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
