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

On Fri, Jan 1, 2016 at 1:18 PM, Luuk <luuk34@gmail.com> wrote:

> reply below....
>
> > <SNIP>

> This was the second link i gave you
>
> it says:
> Example
> |select Article.* from {oj item LEFT OUTER JOIN orders ON item.no
> =orders.ANR}
>
> The link was:
>
> https://help.libreoffice.org/Common/Special_Settings#Use_Outer_Join_syntax_.27.7BOJ_.7D.27
>
> i do not see any '{', 'oj', '}' in your statement
Thanks Luuk.  I guess I misunderstood the information.  Reading the top of
the page, I got the idea that the '{', 'oj', '}' part should be "activated"
so to speak in the settings.  I realize now it is part of the SQL statement.


Regards,
Don
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software Advocate
http://dcparris.net/ <https://www.xing.com/profile/Don_Parris>
GPG Key ID: F5E179BE

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted