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