Subject RE: [firebird-support] Re: select question - faster method
Author Planles
> As long as there aren't any duplicate records in Table 2, you can try
> this:
> select Table1.*, Table2.Field2
> from Table1
> join Table2 t2a on Table1.Field1 = Table2.Field1)
> where not exists(select * from Table2 t2b
> where t2b.Field1 = t2a.Field1
> and t2b.Field2 < t2a.Field2)
> and ( condition...)
> Report back to this list whether this is faster, identical or slower

I haven't noticed any big difference, but as I said, I have at the moment
just a few houndred records in Table. Later this week I'll prepare table
with a lot more data and if I'll notice any difference, I'll come back with