In the last episode (Dec 19), Joseph Dietz said:
> Someone helped me solve the problem with my slow query results! I was
> missing the index which I should have added to my cross reference
> tables.. AND I should have used the INNER JOIN clause instead of
> joining my table with the WHERE clause. In the future I will be far
> more careful designing my queries.
INNER JOIN and WHERE do the same thing:
* `INNER JOIN' and `,' (comma) are semantically equivalent. Both do
a full join between the tables used. Normally, you specify how the
tables should be linked in the WHERE condition.
--
Dan Nelson
dnelson@stripped

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.