>I need a select SQL statement for a medical system that select records matching something like:
>
>admitted during a set period
>status=urgent
>lead consultant=Smith OR lead consultant=Jones
>
>without the OR requirement it is easy but how can I use the OR filter when I have more than one other filter?
If the number of consultants in the list is not more than about 20 then try
WHERE... AND INLIST(lead_consultant, "Smith ", Jones ")
being careful to PADR the names to the correct number of characters
Précédent
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