Run three queries in all....one for each table (dumping the results into a newly-created table) and one against the results table you create from the first two.
Or create a new table using a query with just the common information, then use that table to extract the remaining data from their respective tables.
Or create a new table using a query with just the common information, then use that table to extract the remaining data from their respective tables.