[Zope] multiple selects are not allowed

[Ivan Cornell]

>
> >Diny, why do you need to execute multiple selects in one SQL-Method?
> >
> Belief me, you don't want to know ;)
>
> I'm building a database application for the drugstore department.
> Veterinarians can find medicines by searching on animal, ingredients,
> diseases etc. When they've found one medicine all the detailed information
> about this particular medicine is being displayed. At this point i thought
> i could use the multiple selects.
> The medicine has a 1 to many relationship with animals, ingredients,
> diseases etc. all stored in different tables. When i use one single select
> statement with several where conditions, and one relationship isn't filled,
> the query returns nothing at all.
>
> >Maybe there is another way of doing it?
> >
> I'll split up one complex ZSQL method into several simple methods.
>

Without seeing your queries, I would say use sql's UNION command, eg,

SELECT name FROM animals WHERE id =21 UNION SELECT name FROM diseases WHERE id
=21;

regards, Ivan