[firebase-br] SQL Complexa ainda mais

[DanielN]

tente este select

select x.*
from teste x
where x.matricula = :matricula
   and (( :mes between extract(month from X.data_inicio) and 
extract(month from X.data_final))
   and ( extract(year from X.data_inicio)=:ano ) and X.data_final is not 
null )
    or (( :mes >= extract(month from X.data_inicio) )
   and ( extract(year from X.data_inicio)=:ano ) and X.data_final is null )
    or (( extract(year from X.data_inicio)<=:ano ) and X.data_final is 
null)

somente foi colocado um igual na ultima linha

Em 30/06/2010 09:21, Hélio Oliveira escreveu:
> select x.*
> from teste x
> where x.matricula = :matricula
>   and (( :mes between extract(month from X.data_inicio) and 
> extract(month from X.data_final))
>   and ( extract(year from X.data_inicio)=:ano ) and X.data_final is 
> not null )
>    or (( :mes >= extract(month from X.data_inicio) )
>   and ( extract(year from X.data_inicio)=:ano ) and X.data_final is 
> null )
>    or (( extract(year from X.data_inicio)<:ano ) and X.data_final is 
> null)