Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SELECT ... JOIN Syntax
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
SELECT ... JOIN Syntax
Divers
Thread ID:
00126277
Message ID:
00126277
Vues:
66
Any of the SQL gurus out there have an opinion or two on the following code?
SELECT gsf1.*, classify.classcode, classify.classgrup ;
    FROM gsf1 ;
        LEFT JOIN classify ON gsf1.contactno = classify.contactno ;
            AND classify.classgrup = 'JOBTYPE'
It really bugs me to be joining on more than the keys, but if I don't do it this way, I have to do a separate select to restrict classify before joining the two results. Is this kosher?
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform