Keyed Table Mechanics

Community Support
1

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

?

2

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.