Index used in query?

Can the SQL engine use both index1 and Index2 in the following scenario?

Table1

   Field1
   Field2
   Field3
Index1 on Field1,Field2

Table2

   FieldA
   Field1
   Field2

Index2 on FieldA,Field1,Field2

Query
Select .....
From Table1 A, Table2 B
Where (A.Field1 = B.Field1 )
and ( A.Field2 = B.Field2 )
and (B.FieldA = 1234 )

Thanks - Clive Received on Mon Aug 02 1999 - 15:15:40 CDT