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?
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?