|Subject||Re: [firebird-support] select *at least* N rows|
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”
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
|Wolny od wirusów. www.avast.com|