Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Outer joins in Oracle and VFP
Message
From
25/02/1998 15:13:09
 
 
To
25/02/1998 09:31:06
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00081056
Message ID:
00081170
Views:
18
>Hello everybody,
>
>
>I got an interesting problem. I do the conversion from Oracle SQL statement
>to VFP. In Oracle SQL I see the following code in Where clause:
>
>where bls.gesch(+) = gts.gesch
>
>No problem, it is just left outer join in VFP. But I stumped with next
>clause:
>
>where bls.buch_art(+) = [9999]
>
>If I right understand, outer joins (and joins in general) can be performed
>only on two fields, if so, how this clause can be converted to VFP???
>TIA

Vladimir

I am new to Oracle, but I guess it is a left outer join where
bls.buch_art=9999, I let know if I find anything new
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform