I have a TABLE1 with POSTAL CODES, and TABLE 2 MASTER POSTAL CODES. The TABLE1 has matching Postal codes in Table 2.
I would like to count only the matching Postal codes between the two. These are separate tables, and there is no common field to join them. I tried creating a resident table but then i need to first join them at least or somehow use two residents which i dont think i know how?