sql - How to search same data on two different tables with same column names

Question

I have two tables with different names but similar schema and different data on them. I would like to search for certain data on both tables and combine the results.

for example:

Table A: time, brand, model, color, engine_type

Table B: time, brand, model, color, engine_model

engine_type and engine_model has the same data in reality, but column name's are different

I would like to search certain engine_type or engine_model on both tables and show results. How can I do it?

question from:https://stackoverflow.com/questions/65623203/how-to-search-same-data-on-two-different-tables-with-same-column-names

Answer 1

Use a union query:

SELECT * FROM TableA WHERE engine_type = 'some value'
UNION ALL
SELECT * FROM TableB WHERE engine_model = 'some value';