Information générale
Catégorie:
Codage, syntaxe et commandes
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement