|
Home > Archive > dBASE Programming > June 2007 > SQL problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| Not sure if this can be done, and normally writing a post helps me , but
not this time. I have a book program, which stores values such as
author, lead character, and book #, as in which release of a series
containing that character. Would there be an sql statement that would
allow me to select only those books that are first in a series and also
have the second book? I should add here that there is a logical field
for the first book of the series. If there is a solution, it will help
in my other quest, to find second books where the first has already been
read. I am sure I could use do while loops, just looking for that quick fix!
Thanks,
| |
| Sébastien de Breuck 2007-06-19, 1:20 pm |
| Glenn Wrote:
Would there be an sql statement that would
> allow me to select only those books that are first in a series and also
> have the second book? I should add here that there is a logical field
> for the first book of the series. If there is a solution, it will help
> in my other quest, to find second books where the first has already been
Not sure I understand your question right, but if you have a common data in a field for all the books of the same serie (ex serie name or nr), than you can use this field to select all the books of the same serie
Hopes this can help you, else don't hesitate to ask again, best regards,
Sébastien
|
|
|
|
|