If I had a query

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

Would interbase create the cartesian product of these two tables and
then find the where condition records ?

Or - would it optimise the query to do an inner join automatically ?
Or - is an innerjoin any better ?

Thanks - Rod