[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Inner join vs. outer join

From: Dr . Jürgen Sauermann
Subject: Re: Inner join vs. outer join
Date: Tue, 14 Apr 2020 11:36:28 +0200
User-agent: Mozilla/5.0 (X11; Linux i686; rv:60.0) Gecko/20100101 Thunderbird/60.6.1

Hi Elias,

which spec are you referring to?

Best Regards,

On 4/14/20 6:06 AM, Elias Mårtenson wrote:
I was reading the spec on outer join to see if I could finally fully understand how it works.

For reference, the spec refers to the syntax as follows:

    X a.b Y

The function a is referenced twice in the description for this function, both times in the form a/ (i.e. with the reduce operator applied).

I then noted that the J version of this function does not apply the reduce operator. I.e. in J, you have to do:

    X a/.b Y

Now, am I correct in my assumption that with this change, there would be no need for the ∘ (null function)? I.e. if APL behaved like J, would the following achieve an outer join?

    X ⊣.× Y

I'm still not sure I fully understand the join operator to the point where I can answer this question.


reply via email to

[Prev in Thread] Current Thread [Next in Thread]