Get Database to Acknowledge one book written by two people

You can't keep the tables you have since you can't use FKs with temp tables or table variables.

however, if for the last table you want FOREIGN KEY: ISBN, EDITION then you need to concatenate the two into one column, perhaps as a computed, persisted column and use that as the PK/FK pair.

However I would encourage you to study what I posted and adapt it to your situation. It is a more industry-standard approach and is free from the problems you are having.