Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Oddity
Message
From
14/10/1997 16:45:24
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQL Oddity
Miscellaneous
Thread ID:
00054536
Message ID:
00054536
Views:
73
The following SQL runs great:

SELECT (a bunch of fields)
FROM temptest!memb JOIN temptest!leghist;
INNER JOIN temptest!campus;
INNER JOIN temptest!isd;
INNER JOIN temptest!local ;
ON Memb.mlocalnum = Local.localnum ;
ON Isd.isdnum = Campus.cisdnum ;
ON Campus.campusnum = Memb.mcampusnum ;
ON Memb.membnum = Leghist.lmembnum;
WHERE Leghist.lmembnum = 1;
AND DELETED() = .F.;
ORDER BY Leghist.ldate DESC

but when I change the first join to an outer join;

SELECT (a bunch of fields);
FROM temptest!memb LEFT OUTER JOIN temptest!leghist;
INNER JOIN temptest!campus;
INNER JOIN temptest!isd;
INNER JOIN temptest!local ;
ON Memb.mlocalnum = Local.localnum ;
ON Isd.isdnum = Campus.cisdnum ;
ON Campus.campusnum = Memb.mcampusnum ;
ON Memb.membnum = Leghist.lmembnum;
WHERE Leghist.lmembnum = 1;
AND DELETED() = .F.;
ORDER BY Leghist.ldate DESC

the SQL progress bar pops up, goes straight to 100%, and sits there for about 3 minutes. What would cause this?
Erik Moore
Clientelligence
Next
Reply
Map
View

Click here to load this message in the networking platform