Hello to anyone who comes across this.
I have two tables in the same database
I am looking to update Store_Manager_ID in table 1 that is currently blank with the result from securityPrincipal in Tablet 2 where the Email address's in both tables match all this needs to happen in powershell
Store_Manager_Email - (Contains Email Address)
Store_Manager_ID - (Blank)
user.mail - (Contains Email Address)
securityPrincipal (Contains User ID)