Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Left out join question
Message
De
27/01/2004 17:37:31
 
 
À
27/01/2004 17:29:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00871156
Message ID:
00871162
Vues:
19
Deleted records?

>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform