Matching Asset List to Unit

I have 2 tables as follows:

Table1:
Table1.png

Table2:
Table2.png

I want to match the asset number in brackets in Table2 to asset in Table1, to produce a third table:

Table3:
Table3.png

Any help highly appreciated!

Thank you.
Joseph