The outline for the FROM clause for a LEFT OUTER JOIN isFROM “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?
--Dan -- 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
