I had a question about how exactly the join (JOIN) in sql works. In particular, in what order the lines go.
Ie, for example, there are 2 tables A and B:
A: B: 1 1 1 5 2 3 2 8
Communication will be on the first field.
SELECT A.number, B.number FROM A JOIN B ON A.number = B.number
How will the strings go (meaning not in the result set, but during processing)? Like it or not:
1 1 1 2 2 1 2 2
Where can I read about it?