I am trying to write a SQL Insert trigger which would populate the value of a
column in the inserted row with the value of a column from another database
table. The table into which the row is inserted does not have a primary key
match with the other database table. The two tables can be related through a
join to a third table.