HiWhy "list(x.tbl2_pk_id)"?Result of list is a blob string with one single value like '1,2,3' not a 3 records '1', '2', '3'.And using "in" is not a good choice here. Change query to e.g. 'exists' or better some 'join'Regards,Karol Bieniaszewski null
RE: [firebird-support] Plan problem en CTE
liviuslivius liviusliv...@poczta.onet.pl [firebird-support] Tue, 31 Dec 2019 02:15:23 -0800
- [firebird-supp... Germán Balbi bal...@yahoo.com [firebird-support]
- Re: [fire... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
- Re: [fire... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
- Re: [fire... setysvar setys...@gmail.com [firebird-support]
- RE: [fire... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]