I'm trying to normalize a database to addresses and zip codes. However, there is a situation in which the Post Office allocates, for the same public place, a ZIP code for the side with even numbers and another for the side with odd numbers, and another where the places are divided and, for each division, a zip code for the side with odd numbers and the other side with odd numbers. As there is side in both cases, I created a single table, registering "even side" and "odd side". The problem (ambiguous external join) appeared when I tried to connect the two types of sites to this single Side table, because the bank probably does not know which instruction to perform first, since both require the information in the Side table. Below the illustrative figure:
So,isthereawaytoeliminatethis"ambiguous outer join" error without having to repeat the Side table?
Thanks.