Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL question
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL question
Divers
Thread ID:
00895936
Message ID:
00895936
Vues:
60
Hi,
I have a table like this but the number of name_x fields is variable, from 1 - 253. There
can be any number of dates. And entry of t coressponding to a certain date means that name_x
was present on that date.

dates name_1 name_2 name_3 ........ name_x
d_41201 t f t ........ t
d_41203 f t f ........ f
etc.

Is there a way to use an SQL statement to pull out only those names that were present on a
certain date, even though the number of name_x fields will vary?

Thanks
Steve Elster
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform