Where Clause - Two columns of Primary table mapped to single column in Sec. table
You can join the rows using the following (as suggested by Akina):

WHERE TableA.Name || '_' || TableA.Company = TableB.Name