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 -> Inner Join

Inner Join

From: <ajay.bisht_at_gmail.com>
Date: 21 Mar 2006 23:18:40 -0800
Message-ID: <1143010599.240297.324000@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..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

Original text of this message

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