> 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 (...search 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
result.

Regards,
Primoz