Adding more fields to a Union Query (1 Viewer)

Hello all,

I have a question I have table with the following fields listed below

Inv ()
ID Area Hosting Pc_SN Montior_SN Montior3_SN
1 Houston d13 1 5 9
2 Houston d18 2 6 10
3 Houston d16 3 7 11
4 Houston d11 4 8 12

I built a union query with the following SQL

SELECT [PC_SN] as Serial
FROM Inv
Union
SELECT [Montior_SN]
FROM Inv
UNION SELECT [Montior3_SN]
FROM Inv;

Which displays as:

Serial
1
2
3
4
5
6

What I am trying to do is add additional fields to my query to display as follows:

Serial Hosting Area
1 d13 Houston
2 d18 Houston
3 d16 Houston
4 d11 Houston
5 d13 Houston
6 d18 Houston

Does anyone know how I may do this?

A small question,
Based on the data that you have provided,

Coldsteel said:

I have table with the following fields listed below

Inv ()
ID Area Hosting Pc_SN Montior_SN Montior3_SN
1 Houston d13 1 5 9
2 Houston d18 2 6 10
3 Houston d16 3 7 11
4 Houston d11 4 8 12

Click to expand...

and the query used

Coldsteel said:

I built a union query with the following SQL

SELECT [PC_SN] as Serial
FROM Inv
Union
SELECT [Montior_SN]
FROM Inv
UNION SELECT [Montior3_SN]
FROM Inv;

Click to expand...

you have shown the result

Coldsteel said:

Which displays as:

Serial
1
2
3
4
5
6

Click to expand...

Should this result not be

Serial
1
2
3
4
5
6
7
8
9
10
11
12

Thanks

Thanks for the reply, The data does display as

Serial
1
2
3
4
5
6
7
8
9
10
11
12

I just cut it off for the post. Anyone able to help me with issue?

The rules for a UNION Query are Simple. Each Subset of the Query must have the same number of the same Type of parameters in the same order. If I understand you correctly, you would need to add two new fields for [Area] and [Hosting], making your Query something like the following:

Thanks so much, this helps me greatly