i have two tables
table 1 : fiels (name)
table 2 : fields (name, number, residence, phone, etc…)
i want to join the two tables to include only the records from table 1 and the corresponding values from table 2, table 1 has 191463 records, table 2 has 188894 records.
i have tried the left join but the result hoin includes 197000 records