[V4RB] Outer join strange result in sort order

[Francois Van Lerberghe]

Hello,

I'm using V4RB 1.11 (last version) and Realbasic 3.5

I have a problem with an outer join that don't give me the expected result.
Here is my SQL query :

SELECT table1.field1, table2.Field2
FROM table1, table2
WHERE table1.field1 =* table2. Field2
ORDER BY 1

The results, in viSQL, are :

field1      field2
--------------------
string1     string1
string1     string1
            stringA
            stringB
            stringC
string2     string2
string2     string2
string2     string2
string3     string3
...         ...
(next 14000 rows)

The results don't seem, to me, to be correctly sorted.
Although I have asked "ORDER BY 1", the 3rd and the 3 following lignes (that
have not related record in table 1) are *after* the 2 first ??

Is it a normal behavior with outer join ?
Is it a problem of indexes ?

François Van Lerberghe
Rue Thier Monty, 15 A
4570 Marchin
Belgique