Combining Redundant Fields

[igendreau]

I have 2 tables, and for some long-winded reasons, they have some redundant information. Each table has 20+ fields, but there are a couple of fields that exist in both tables (ID, FirstName, LastName).

Example:
TblA
ID FirstName LastName
1 Joe Jones


2 Bill Burns

TblB
ID FirstName LastName
98 Jim Johnson
99 Lou Larson

I need to present these in one big list, showing these three fields for every record regardless of the table it came from. So my final result would be a query displaying:

ID FirstName LastName
1 Joe Jones
2 Bill Burns
98 Jim Johnson
99 Lou Larson

[pbaldy]

Sounds like you want a UNION query:

SELECT ID, FirstName, LastName
FROM Table1
UNION ALL
SELECT ID, FirstName, LastName
FROM Table2

[igendreau]

Perfect. That'll work. Thanks!

[pbaldy]

Happy to help, and welcome to the site!