Hi Maya

That's the beauty of Firebird version 2.0. You can have selective joins. You
can do something like this

Select a.* from table1 t,
(select t2.id, t2.id2, t3.id3 from table2 t2, table3 t3 where t2.id = t3.id)
t4
Where t.id = t4.id

But unfortunately, its still in alpha stage.


[ extensive requoting removed by Moderator ]