You can try also pseudo inner join (left join with where clause) Instead of
T1 INNER JOIN T2 ON T1.ID1=T2.ID2 change it to T1 LEFT JOIN T2 ON T1.ID1=T2.ID2 WHERE T2. ID2 IS NOT NULL regards, Karol Bieniaszewski
Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] Fri, 01 May 2020 02:57:13 -0700
You can try also pseudo inner join (left join with where clause) Instead of
T1 INNER JOIN T2 ON T1.ID1=T2.ID2 change it to T1 LEFT JOIN T2 ON T1.ID1=T2.ID2 WHERE T2. ID2 IS NOT NULL regards, Karol Bieniaszewski