Not sure how you select the household
>
> The result is (only the first column is shown):
>
> household_name
>
> "Garcia"
> "Armstrong"
> "Armstrong"
> "Bauer"
> "Bauer"
> "Berst"
> "Berst"
> "Minch (xxxx)"
> "Berst"
> “Besel”
but unless you select from the resulting table using again an order by, the rows will be returned in an undetermined order. Such is the nature of the relational model - there is no order you can rely on when selecting, unless you specify it
Hth,
Peter