Skip to Content
0
Former Member
Sep 23, 2010 at 05:31 PM

Union All Command

865 Views

>

> Sometimes Crystal can not manipulate the data as you want. Building a query and using that as a command gives you greater flexibility.

>

> In the case of needing to access data twice you can union data as required

>

> Select Field1, field2, field3 from table1

> Union all

> Select Field1, field2, field4 from table2

>

> Number of fields and data types must be the same in each query.

>

> Ian

Once I retrieve duplicate fields, how do I reference the them when I build the report?