Update system/cms/modules/streams_core/field_types/relationship/field.relationship.php

Streams in the pages namespace are spread out over two tables
Joining these two tables is necessary to get the page titles and the right page IDs for the options in the relationship dropdown menu