I am working on a Tax Property Parcel project. I have a parcel layer that has 86,834 records and I am needing to joining three tables to this layer. However, each table does not match with the number of records I have in my parcel layer. I have tried to join the parcel based on the pin parcel id field to the commercial, residential and combine residential/ commercial table picn id. Every Time i do the join the results in the attribute is null. Is there a way to join a layer that has more records than the table?