• I have attached the results of sp_help's on the tables, and the sql statement