Subject Re: [firebird-support] How to join records
Thank you Ann, Thank you Set,

yes, in my real situation I have to extend the query to other fields from T2 - therefore the second solution seems to be the better one for me.

Could "Common Table Expressions" or "Derived Tables" bring any advantages?