Hi, I have two tables, each has seven columns, not including the ID column.

Let's say the first table has four columns of data (account number short detail, account number long detail, budget category, and date) and the final three columns are english units of length, height and width.

Let's say the second table has four columns of data (account number short detail, account number long detail, budget category, and date) and the final three columns are metric units of length, height and width.

The first table has 10,059 rows, while the second table has 3,660 rows. As you can imagine, this is how I the data came out of another database.

How do I connect the two tables so that I can create a query which displays the four columns of data, followed by three columns of english units, followed by three columns of metric units, for parts that have both units available?

Can't find this on tutorials anywhere. Don't hesitate to explain even the simplest of steps. Thanks in advance!