Union fields and rows

[Razor]

Hi,

Is it possible to create a union of two tables in records
as well as fields?

In other words I want to collpase the two tables into one
without losing any data.

Thanks,
Razor

 

[John Spencer (MVP)]

Use UNION ALL vice a UNION