Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Statement using 5 tables
Message
From
14/04/2004 10:08:43
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00894654
Message ID:
00894761
Views:
8
I'm trying to scale back the SQL statement...doesn't like this either

SELECT H.CUSIP, H.ACCOUNT, NVL(sourcedoc.doc_recv,'Not Defined') AS source_doc;
FROM holdrecn H, sourcedoc;
WHERE &itemtype and h.source_num=sourcedoc.source_num(+)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform