Re: [libreoffice-users] LOBase Query - Left or Right Join?

On 01-01-16 13:08, Don Parris wrote: Hi all, I have a set of tables for contacts, and a somewhat complex query that seeks all the available contact information on a subset of the contacts. By "incomplete result set", I mean I have one contact that does not show up in the query results, but

[libreoffice-users] LOBase Query - Left or Right Join?

Hi all, I have a set of tables for contacts, and a somewhat complex query that seeks all the available contact information on a subset of the contacts. By "incomplete result set", I mean I have one contact that does not show up in the query results, but should. I know why: that contact has phone

Re: [libreoffice-users] LOBase Query - Left or Right Join?

On Fri, Jan 1, 2016 at 10:59 AM, Luuk wrote: > > > > >> >> >> > > In design mode, right-click on the link between two tables, and click > 'edit'... > > > If you want to manually edit the SQL, the syntax is shown here: > >