This is a super simple problem, not sure what is going on but I am hoping a fresh set of eyes might help.
All I am trying to do is take the 'property_address' column from the powerlender table and use that information onto the foreclosure table - foreclosure is otherwise all ready to go.
Both tables have a loan_id (one is called application_key) that are in different formats. I alter the columns so that each of them are in integer form
The powerlender tables has all of the same loan numbers (and addresses that i am missing from foreclosure are in there) as the foreclosure table so it is not missing data
when i go to add the property_address column to the foreclosure table, (and call it 'address') they are not populating as one would expect.
Any ideas of what might be the issue?
Thanks in advance