Subject RE: [firebird-support] Re: Full joins...
Author Alan McDonald
> That's at least not true for Fb 1.0.2, which I am still using.
> I simply did:
> select * from rdb$fields f
> left join rdb$database d on d.rdb$relation_id = f.rdb$segment_length
> and it returned all records in rdb$fields even though many had NULL in
> segment_length.
> Are you saying that this has changed in Firebird 1.5 and that the
> above query
> would return only those records that had did not have a NULL value in
> rdb$fields.rdb$segment_length ???
> Set

v1.5 on my box returns nulls in segment_length