Combining Fields from multiple Tables

[mainerain]

I would like to combine Fields from different tables into a "Master" Listing. What would the query look like? Just one field from each table that are identical. For instance, Serial Numbers field from different Model Tables so that there is a combined Master listing of all Serial Numbers. Thanks.

[CJ_London]

What would the query look like?

depends what the tables look like.

Either it will be a select query where each table is linked to another on a suitable unique value field or you would use a union query where each table contains the same type of information.

I suspect the latter, so something like

SELECT SerialNo FROM tbl1
UNION SELECT SerialNo FROM tbl2
UNION SELECT SerialNo FROM tbl3
etc

this can only be written in the sql window

Your question implies you are either bringing data together from multiple sources into a normalised system or you have an unnormalized database. If the latter, this is something you will need to address as it will become harder and harder to manage over time.

[mainerain]

The Union query worked great. Thanks so much! How do I name the field that is created in this Master list?

[CJ_London]

How do I name the field that is created in this Master list?

it will take the name of the first select e.g.

SELECT SerialNo AS MasterSerialNo FROM tbl1
UNION SELECT SerialNo FROM tbl2
…
…

[mainerain]

Ok. I noticed that, I just didn’t know if there was a way to rename it to something more appropriate. Thanks