Query with union

rbuser

Hi,

I'm using D6 and RB7.02.

I want to create a query with 'union' via the QueryDesigner.
Is it possible?

Example of Query :

select * from Table1
union
select * from table2

thank's.

digitalmetaphors

Not all of the features in SQL are supported visually. Union is one that
isn't supported visually. You'll have to choose to edit the SQL manually to
ues this SQL in a dataview. You will lose the query tools support on this
dataview once you edit the SQL.


Cheers,

Jim Bennett
Digital Metaphors