Is aj supposed to have a dependance on the order of the join columns?

Subject says it all. The book does not hint at it but it looks like itdoes.

To answer my own question, this seems to be a symptom of an unsorteddate/time column; aj assumes it is sorted.

Yes, the second table needs to be sorted. See also the discussion insection 9 of http://kx.com/q/d/q.htm .On Mar 17, 7:15?am, annakh7 <anna…> wrote:> To answer my own question, this seems to be a symptom of an unsorted> date/time column; aj assumes it is sorted.</anna…>