Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Outer join in VFP3 report writer
Message
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00086031
Message ID:
00086040
Views:
25
>I am using VFP3.0b for Windows.
>
>Very strange thing happened. I joined two tables in the data environment of the report writer (to do a very simple report). Instead of the usual join it did a OUTER JOIN!
>
>Has anybody noticed this behaviour? Is this a bug, feature or by design?
>
>I could exploit this...

I have not seen this - as 3.x does not support outer joins - other than by doing it with a UNION clause. I would have said it is a cartesian product - except I don't know how would pull that off in the DE. In code, it is easy - just forget the join in the where.
Previous
Reply
Map
View

Click here to load this message in the networking platform