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

reply below....

On 01-01-16 18:06, Don Parris wrote:
> Update:  I did try re-writing the query with LEFT/RIGHT JOINS, but all I
> get are syntax errors.  Maybe I have my SQL statement incorrect?
>
> SELECT "tCoreCategory"."category", "tCntEntity"."entity_name",
> "tCntPerson"."first_name", "tCntPerson"."last_name",
> "tCntAddress"."location_name", "tCntAddress"."address1"
> FROM "tCntEntityCategory" JOIN "tCntEntity" ON
> "tCntEntityCategory"."entity_id" = "tCntEntity"."entity_id" AND
> "tCntEntityCategory" JOIN "tCoreCategory" ON
> "tCntEntityCategory"."category_id" = "tCoreCategory"."category_id" AND
> "tCntEntityPerson" JOIN "tCntEntity" ON "tCntEntityPerson"."entity_id" =
> "tCntEntity"."entity_id" AND
> "tCntEntityPerson" JOIN "tCntPerson" ON "tCntEntityPerson"."person_id" =
> "tCntPerson"."person_id" AND
> "tCntContactAddress" LEFT JOIN "tCntEntity" ON
> "tCntContactAddress"."entity_id" = "tCntEntity"."entity_id" AND
> "tCntContactAddress" LEFT JOIN "tCntPerson" ON
> "tCntContactAddress"."person_id" = "tCntPerson"."person_id" AND
> "tCntContactAddress" LEFT JOIN "tCntAddress" ON
> "tCntContactAddress"."address_id" = "tCntAddress"."address_id" AND
> "tCoreCategory"."category" LIKE 'Internal -%';

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
|

--
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