--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@i...> wrote:

> At 05:56 PM 8/31/2004, Bill Meaney wrote:
>
>
> >You might try this:
> >
> >select <misc cols>, t1a.Description, t1b.Description
> > from table2 t2, table1 t1a, table1 t1b
> > where t2.Simple = t1a.Key
> > and t2.Another = t1b.Key
>
> And be sure you've got an index on the table1 key field.
>
> Regards,
>
>
> Ann

The table1 key field is the primary key for the table. Is there any
other way to improve the performance of a query to accomplish this
task? I really appreciate all the help.

Jay