On Tue, Jan 5, 2016 at 5:15 PM,
wrote:
> Don Parris wrote:
>
>> 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
Don Parris wrote:
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" =
On Sat, Jan 2, 2016 at 4:36 AM, Luuk wrote:
>
>
> On 01-01-16 22:08, Paul Steyn wrote:
>
>> Hi Don,
>>
>
>
> 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.
On 01-01-16 22:08, Paul Steyn wrote:
Hi Don,
Your SELECT statement is indeed incorrect; it seems as though you don't
fully understand joins (I could be mistaken, but your syntax is off
by enough to suggest this).
Firstly, choose a format for your SELECT statement to make it easier to
read.
On Fri, Jan 1, 2016 at 1:18 PM, Luuk wrote:
> reply below
>
>>
>>
>
> 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:
>
>
On Sat, Jan 2, 2016 at 4:36 AM, Luuk wrote:
>
>
> On 01-01-16 22:08, Paul Steyn wrote:
>
>> Hi Don,
>>
>> Your SELECT statement is indeed incorrect; it seems as though you don't
>> fully understand joins (I could be mistaken, but your syntax is off
>> by enough to suggest
Hi Don,
Your SELECT statement is indeed incorrect; it seems as though you don't
fully understand joins (I could be mistaken, but your syntax is off
by enough to suggest this).
Firstly, choose a format for your SELECT statement to make it easier to
read. I've reformatted it below using one such
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",
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",