Subject RE: [IBO] Select with UNION in queries and filtering
Author Jason Wharton
> I have a query with a union between two select. It works well.
> But I need to apply a filter on the result table.
> The filtering presently applies on the first table only.
> Is there a way to filter the whole result table ?
> Thanks in advance for your answers.
> Marie

Yes, IBO is limited in how it can deal with UNION statements. Sorry about
that. I actually have stubs in my code for a future feature that will allow
an array-like way to access each of the SELECT statements separately and so
that I can also detect and handle this situation for you.

For now, I think the best way to deal with this is to use the macro
capability and supply the SQL yourself.

Hope this helps,
Jason Wharton