At 26/11/2002 02:34 PM, you wrote:

>Hi people,
>
>I have a database with Dialect 1 and 8K Page Size running on my development
>machine that is a PIII 1GHZ 256 MB RAM on Windows XP. I need to run the
>following query:
>
>select
> min(T.Data)
>from
> Turno T join
> MaquinaOcupacao MO on (MO.TurnoID = T.TurnoID)
>where
> T.Data > '2002-12-01' and
> MO.MaquinaID = 17

Try:

select
min(Turno.Data)
from Turno
where (Turno.Data > '2002-12-01')
and exists (select * from MaquinaOcupacao
where (MaquinaOcupacao.MaquinaID=17)
and (MaquinaOcupacao.TurnoID=Turno.TurnoID))

This is just a different way to write your query to retrieve the same
result set.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)