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

On Sat, Jan 2, 2016 at 4:36 AM, Luuk <luuk34@gmail.com> wrote:

> On 01-01-16 22:08, Paul Steyn wrote:
>
> > Hi Don,
> > <SNIP>

> You are absolutely right, but the *syntax* is different in LO ....
> >
> see link i posted earlier
>
>
>
>
> Still trying to work out the OUTER JOIN syntax apparently.  I tried a
simpler outer join statement:
SELECT
"tCoreType"."type" "Type", "tCoreCategory"."category" "Category"
FROM {oj "tCoreType" "ctype" LEFT OUTER JOIN "tCoreCategory" "ccat"
  ON "ctype"."type_id" = "ccat"."type_id"}


This gives me the following error:
SQL Status: S0022
Error code: -28

Column not found: tCoreType.type in statement [SELECT "tCoreType"."type"
"Type", "tCoreCategory"."category" "Category" FROM      "tCoreType" "ctype"
LEFT OUTER JOIN "tCoreCategory" "ccat" ON "ctype"."type_id" =
"ccat"."type_id"  ]

The column "type" is most certainly one of the columns in the specified
table.  No matter what order or how I try to enter this, it just comes up
with an error message.  Any ideas?  I really would like to learn how to
make this work.

-- 
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software Advocate
http://dcparris.net/ <https://www.xing.com/profile/Don_Parris>
<http://www.linkedin.com/in/dcparris>
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