Hi Karol, perfect! I usually say that I hate DBs but the more I gain deep insights I start to like it.
Thank you for your help! Matthias liviuslivius liviusliv...@poczta.onet.pl [firebird-support] < firebird-support@yahoogroups.com> schrieb am Mi., 4. März 2020, 19:38: > > > Pseudo inner join is left join with where clause about not null from left > joined table > > Select > .... > From > Table1 t1 left join Table2 t2 on t1.id=t2.id_t1 > Where > t2.id is not null > > Regards, > Karol Bieniaszewski > > >