Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> When to use inner join

When to use inner join

From: <ajay.bisht_at_gmail.com>
Date: 22 Mar 2006 21:10:07 -0800
Message-ID: <1143090607.357589.237780@t31g2000cwb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US