Subject RE: [IBO] Select with UNION in queries and filtering
Author Helen Borrie
> > 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

At 11:52 AM 31/05/2007, Jason wrote:

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

If you are using Firebird, you can make a view of your union-ed
set. With this as your base set, you can filter and order your
dataset however you like.