Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Combining two tables
Message
De
27/07/2012 10:34:44
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01549418
Message ID:
01549429
Vues:
37
The inner join includes "only" the T1 records that match customer numbers in T2.

I want all the customer numbers in both tables to be in the resultant table

I have customer numbers that only exist in each table so they are excluded from the join?

So if there is a customer that we did not have any sales with in one of the two years, it is omitted from the result. I need them to be included in the comparison showing the sales total as zero in the year nothing exists.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform