Yes, but remember about good join condition then and if needed sort condition especially you can use system table e.g. RDB$RELATION_FIELDS (it contain many records also in empty database) and JOIN on RDB$RELATION_NAME=’RDB$DATABASE’ AND RDB$FIELD_ID=0 instead of “G.OUT_NO=1”
regards, Karol Bieniaszewski From: shg_siste...@yahoo.com.ar [firebird-support] Sent: Friday, March 23, 2018 9:03 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] select *at least* N rows That's a very interesting solution as well Karol! Thanks! I've just realized that I can "left join" my table against *any* table which I know it already has enough records for my purpose --- Ta wiadomość została sprawdzona na obecność wirusów przez oprogramowanie antywirusowe Avast. https://www.avast.com/antivirus