Subject | RE: [firebird-support] select in (subquery) |
---|---|
Author | Mauricio I Magni |
Post date | 2004-12-01T22:23:11Z |
Hello
build a join clause. Then I think the best way to limit the query is using
the "where ... in (select ...)".
Mauricio.
> If you want a join, why not simply use a join. These "IN" and "EXISTS"Yes, you are right. I forgot tell that I'm doing an update, and then I can't
> statements proved several times to be too slow. They are simply fast when
> you don't retrieve too many records, or if they are static.
build a join clause. Then I think the best way to limit the query is using
the "where ... in (select ...)".
Mauricio.