Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> When to use inner join
There are two queries:
1. SELECT
RR.*, a.NAME
FROM
T_test1 RR INNER JOIN
T_test2 A
ON
A.CODE =RR.LOCCODE
2.SELECT
RR.*, a.NAME
FROM
T_test1 RR , t_test2 a where A.CODE =RR.LOCCODE
they are giving the same recordset.
--> when to use Inner join
-->Is there any diff. b/w these two queries
Received on Wed Mar 22 2006 - 23:10:07 CST