Concatonate / Join results

[mimi12]

Hi all,
Here's my data

CM1 CM2 ADDR
--- --- ----
A B 2, Edgware Road

These customers are joint account holders. Management wanted us to treat this as a two customer relationship.

So, how do I set up the query manager to return

CM ADDR
--- -----
A 2, Edgware Road
B 2, Edgware Road

Tried using the union joins, but somehow it doesn't seem to work. CM1, CM2, ADDR are dimensions.

Cheers,
Mimi

 

[ATP]

Using Union in the query pannel should work.

In the query pannel, select CM1 and ADDR
Press the "Combine Query" button.

This will create a second query.

On this second query, replace CM1 with CM2.

A Combined query works as long as the number of fields and the types match.