In Ingres, the rows from tab1 are returned first in the query results, followed by the results from tab2.