General information
Category:
Coding, syntax & commands
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only