Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use nulls from outer join in SQL Union
Message
 
To
16/11/1998 10:50:05
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00157837
Message ID:
00157850
Views:
31
>Try SET NULL ON and/or SET NULLDISPLAY TO "".

I tried it, and it did not work. Thanks for the suggestion! I hope you have more. :)

I guess I could scrap the LEFT OUTER JOIN and go back to the old way of handling outer joins, that is, NOT EXISTS (subquery) or value NOT IN (sub query). I would rather not, since it looks like the LEFT OUTER JOIN syntax runs faster.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform