Joining two tables but one of the tables does not contain a uniqueID in SQL Server

I have the following SQL ode:

Joining two tables but one of the tables does not contain a uniqueID MSSQL

I have the following sql code: