Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Mult join to the same table does not work
Message
From
17/12/2003 10:55:23
Michael McHugh
Sidel Canada
Laval, Quebec, Canada
 
 
To
17/12/2003 10:05:14
Peter Cortiel
Retired
Willington, Connecticut, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Mult join to the same table does not work
Miscellaneous
Thread ID:
00859887
Message ID:
00859930
Views:
15
Hi Peter,

Would this work

SELECT file1.* FROM file1 ;
LEFT OUTER JOIN file2 ON file1.id = file2.id ;
WHERE INLIST(file2.ltype, "AA", "BB")


HTH
Mike
Previous
Reply
Map
View

Click here to load this message in the networking platform