Combining two columns into one output 1

[rilkyn]

I have two tables both containing two columns as follows


Batch Associate Table
Element
Table Name

Online Associate Table
Element
Table Name

I need to combine the two Table Name columns into a single column output so that I have a total list of all Table name records from both tables.

Is this possible?

 

[ZmrAbdulla]

Use a Unoion Query to achieve this

SELECT [FirstTableName].Field1, [FirstTableName].Field2
FROM [FirstTableName]
Union Select
[SecondTableName].Field1, [SecondTableName].Field2
FROM [SecondTableName];

Use Square brackets for field name also if the name includes spaces. It is a good habbit to avoid spaces in contol names
Eg: FirstName or First_Name

Zameer Abdulla
Visit Me

 

[rilkyn]

Thanks

That's spot on.

Rilkyn