Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to use nulls from outer join in SQL Union
Message
 
À
16/11/1998 10:50:05
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00157837
Message ID:
00157850
Vues:
24
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform