Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL select question
Message
De
30/03/2008 20:19:19
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01306837
Message ID:
01306853
Vues:
7
>You're right. Funny, that I didn't think of a UNION. In this case UNION sounds better, I think. But both solutions would work, though UNION could be faster, though I'm just speculating here.
>
>BTW, instead of DISTINCT your meant UNION ALL (vs. UNION). In Dmitry's case we're looking for UNION.

Indeed, I got that one wrong.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform