Get the same data in two different tables with the same column structure

Question

I have 2 tables with the same column layout, but contain different data entered per year. I need to run a query that will find all the records in both tables where the data in one of the specified columns matches, for example:

id | serialNo | enteredBy | entryDate| processedBy | processDate ...

rows containing the same serial number (link to the same element) in both tables.

Answer 1

Try something like:

SELECT * FROM t1 INNER JOIN t2 ON (t1.serialNum = t2.serialNum)