> -----Original Message----- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp > Sent: Tuesday, October 21, 2014 6:59 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Full outer joins > > > On Tue, Oct 21, 2014 at 7:12 PM, Paul Sanderson < > sandersonforens...@gmail.com> wrote: > > > out of interest why are > > full out joins not supported? > > > > In 14 years, you are the first person to ask for them. That > tells me that > probably not many people would use them even if we did put them in. ...
I'll be the second; I needed it last week. I was able to get by for my particular problem, because the full range of keys is well-known, so I could make a table of those to drive a series of outer joins. The work around referenced in other posts is useful in a pinch, though it would be messy in my case because I am joining 4 tables. -dave _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
