Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Joining three tables (2 twice) with a left outer join
Message
From
11/01/2000 09:04:18
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00315817
Message ID:
00316121
Views:
25
David Frankenbach, you're my hero!

It works like a champ. I didn't realize that I could include secondary where conditions as part of the join statement. So I had moved the tbl1.field_name = 'padmis' down into my where clause.

At any rate, I now get a left outer join, exactly the way I wanted. Thanks again, man!
--Todd Sherman
-Wake Up! Smell the Coffee!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform