Good Afternoon,
I am hoping this is possible, any help is appreciated:

I have 2 tables:

Table 1
CC# Router#
1002 1
1002 2

Table 2
CC# Switch#
1002 3
1002 4
I am trying to get:

Report 1:
1002
Router
1
2
Switch
3
4

but my query comes out:
CC# Router# Switch#
1002 1 3
1002 1 4
1002 2 3
1002 2 4

Is there a way to get this result?
--
Thank You,
Steve