Subject | SQLWhereItems and UNION |
---|---|
Author | Boris Schlüszler |
Post date | 2002-06-22T21:22:41Z |
Hi!
I have a query
select val1, val2 from table1 where cond1 union select val1, val2 from
table2 where cond2
and I'd like to use OnPrepareSQL to manipulate SQLWhereItems
How can I control, where the "WhereItems" are inserted in this clause?
Any hints are appreciated.
Regards, Boris
I have a query
select val1, val2 from table1 where cond1 union select val1, val2 from
table2 where cond2
and I'd like to use OnPrepareSQL to manipulate SQLWhereItems
How can I control, where the "WhereItems" are inserted in this clause?
Any hints are appreciated.
Regards, Boris