Ok, thank you Darren. It's good to know that, so I don't waste time trying to implement something that doesn't exist :-)
Are there plans to implement this sometime in the future? Dennis -----Original Message----- From: Darren Duncan [mailto:[EMAIL PROTECTED] Sent: Friday, 1 July 2005 7:31 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SQL syntax - please help I don't think that SQLite supports what you want yet. As soon as the SQL:2003 "WITH RECURSIVE ... SELECT ..." syntax is supported, you should be able to do what you want elegantly. Meanwhile, you will have to do multiple selects to work with N recursions. -- Darren Duncan