Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT ... JOIN Syntax
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
SELECT ... JOIN Syntax
Miscellaneous
Thread ID:
00126277
Message ID:
00126277
Views:
67
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?
Next
Reply
Map
View

Click here to load this message in the networking platform