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?