Saying I 'would like this type of join' is something I say very lightly. By that I mean it'd be good to see them, but, really, I'm not going to put any pressure on anyone to get it implemented.
I'd been using these joins in SQL2K for years before I found out about SQLite and a lot of what I was doing in 2K couldn't be done in SQLite because of the outer joins. Fortunately, the apps for 2K are specifically for 2K and will never be converted to SQLite, but with the lack of capability, I just learned a new way to get my results, which I think was basically make a few queries. This was before I REALLY figured out the unions (Even though it was part of my training back then) On Wed, Oct 22, 2014 at 3:46 AM, Paul Sanderson < sandersonforens...@gmail.com> wrote: > Really!! > > I can accept that it would not be needed as often as other joins but I > can imagine that anyone who wrtes software that populates databases > and who subsequently changes their software or needs to benchmark > against some other datasource would find this useful. > > > Cheers > Paul > > > On 22 October 2014 00:58, Richard Hipp <d...@sqlite.org> wrote: > > 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. > > > > -- > > D. Richard Hipp > > d...@sqlite.org > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
