What happens if 2 wifi networks (run by different people) have the same SSID?

so lets say theres 2 wifi networks run by 2 different people, they both have different passwords:

Wifi network 1 ssid: Example Password: 9238 wifi network 2 ssid: Example Password: 3234

If 2 networks have the same SSID, it shows the strongest connection in available networks right? So lets say I connect to wifi network 1 whilst it is the strongest, I then move closer to wifi network 2 however still in range of network 1. Does it try to connect to wifi network 2 even though the password is different?

It will attempt to connect to the one with the stronger SSID but will fail and go back to the one it can connect to. We had this issue at work before we centrally managed our Wireless APs and forgot to update the password for our guest network.