On Fri, 2012-07-20 at 09:51 -0400, Dan wrote:
> The outline for the FROM clause for a LEFT OUTER JOIN is
>
> FROM “table1 name” LEFT OUTER JOIN “table2 name” ON “table1
> name”.”foreign key” = “table2 name”.”primary key”
>
> This is what I entered into a query yesterday. Yet, today when I
> edited the query in SQL view I saw
>
> FROM { OJ "Persons" LEFT OUTER JOIN "Orders" ON "Persons"."P_ID" =
> "Orders"."P_ID" }
>
> Braces and OJ were added. This is using LO 3.5.5.3. I got a
> similar result when using SQL to create a RIGHT OUTER JOIN. Does anyone
> know where this is documented? It appears Base is adding this for
> clarity. Should this be included this in the documentation?
>
Hi Dan
The use of ODBC conventions, '{ OF' for example, is controlled with an
option on the ODB file.
Open the ODB.
Open the dialog for options:
Edit>Database>Advanced Options
//drew
--
For unsubscribe instructions e-mail to: [email protected]
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
