Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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..My Q is when to use Inner join.Is there any diff. b/w these two queries Received on Wed Mar 22 2006 - 01:18:40 CST
![]() |
![]() |