Assuming we have TableX and TableY, both with FieldA and FieldB, indexed:

Select *
From TableX Inner Join TableY on TableX.FieldA = TableY.FieldA
Where TableX.FieldB = TableY.FieldB

But seriously, I am just speculating.

Jason


Rick Debay wrote:

>>Firebird can use more than one index per table for a query
>
>
> In what cases could FB use more than one index on a table? My guess
> would be only for OR logic in the JOIN or WHERE clause. Are there any
> documents I could read on this, besides the FB Book?