I have a db using firebird-1.0.0.796. I created a self union join and
got strange result.

create view bb (bb_pid, bb_2) as
select a_pid, a2 from a
union
select a_pid, a3 from a

a2 and a3 are computed field. a_pid is the primary key.

Table c
c_pid c_bb_pid
1 4
2 4

select c_pid, c_bb_pid fromc c, bb
where c.c_bb_pid = bb.bb_pid ( RETURN 2 only)

select c_pid, c_bb_pid fromc c, a
where c.c_bb_pid = a.a_pid ( RETURN 1 & 2 )

Is that I do something wrong ? Please advice.

Regards,

Almond Wong



[Non-text portions of this message have been removed]