On Sat, Jan 2, 2016 at 4:36 AM, Luuk <[email protected]> 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: [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
