Combining 2 sets of tables

I have 2 sets of 3 colums with a common colum of data between them e.g.

1st set of columns

Item COST Colour
Car 13 Blue
Bike 30 Green
Table 100 White

2nd set of columns

Colour Year
Green 2008
White 2012
Blue 2017

How do I combine these columns using the "colour" column as the common base

e.g.

Item COST Colour Year
Car 13 Blue 2017
Bike 30 Green 2008
Table 100 White 2012

I have 1000's of rows of data thus I need some sort of automated way of doing this ?

Dear Glenn,

Thank you so much this was exactly what I was looking for !

Best regards

Shmuel