I am trying to do a left outer join between 2 tables matrix and trees. The matrix table has 37550 rows and the trees table has 21484. I want the resultant table to have 37550. Here is the command I am using:

select trees.*, matrix.plot as mPlot, matrix.spc_grp as mSpc_Grp, matrix.dbh_98 as mDBH_98 from matrix left outer JOIN trees on trees.plot = matrix.plot AND trees.spc_grp = matrix.spc_grp AND trees.dbh_98 = matrix.dbh_98 AND trees.status_98 = 8 order by matrix.plot, matrix.spc_grp, matrix.dbh_98

I end up getting 37618 rows. Where are the extra rows coming from?

Any sugestion would be appreciated