Keyed Table Mechanics

https://learninghub.kx.com/forums/topic/keyed-table-mechanics

Why does the select function store the values of kt out of order with respect to the values of t?

The values aren’t stored out of order. As the ID column is acting as a foreign key, the corresponding v values to each ID from the kt table are as follows:

ID          v
1002        200
1001        100
1003        300
1001        100

That’s why they appear in the order they do in the select query. Hopefully that’s clear enough.