Sorry if this is posted twice - my first post did not seem to go
through.

If I had a query

Select * from loan, borrower
where loan.number = borrower.number

would interbase create a cartesian product of the two tables and then
select the where condition records ?

Would using inner join be any better (the result would be the same)
If it is better, If I used the first query, would interbase optimise
and use the join ?

Thanks - Rod