>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?
I may be not understanding what you are asking, but putting everything in brackets may simplfy things :
(admitted during a set period) AND
(status=urgent) AND
((lead consultant=Smith) OR (lead consultant=Jones))
AND
(other filter)
Paul
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