Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Join Confusion
Message
 
 
À
10/06/1999 19:35:28
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00228381
Message ID:
00228923
Vues:
13
Yes, that's what I want.

Thanks,

Michelle


>LEFT OUTER will give the records in the sowgts table even if they don't have a match in some of the other tables. If this is what you want, LEFT OUTER is ok.
>
>Vlad
>
>>Ok, I figured it out. I was right in the first place with using all LEFT OUTER JOINs. The problem was that I only had one part of a two part key on sotran.
>>
>>Thanks, both of you.
>>
>>Michelle
>>
>>
>>
>>
>>
>>>If there is only one match in all the child tables, then a INNER JOIN should get you only one record per record in sowgts.
>>>
>>>>First match? There's only 1 match, so I don't know where first comes into it.
>>>>
>>>>Each record in sowgts has
>>>>* a skid in soskid
>>>>* a sales order in somast
>>>>* a line item in sotran
>>>>* a customer in arcust
>>>>* an address in soaddr
>>>>* a highest numbered skid in highskid
>>>>* a net weight in netwts
>>>>
>>>>I just want to put all of this info into the same record. What would I group by? There's no groups?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform