Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Query with union

edited May 2003 in End User
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.

Comments

  • edited May 2003
    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


This discussion has been closed.