General information
Category:
Coding, syntax & commands
Title:
Left out join question
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only