Conditions on Joined Tables

Hi

I don’t see how to write correctly conditions for the following
query :

association:
client has_many :orders

I would to get in one query :

all clients with NO ORDER + clients with orders where Today IS NOT in
range (order.start_date… order.end_date)

is it possible or should I write 2 queries then join the resulting
arrays ?

thanks

erwin