Re: Inner Join

ajay.bisht_at_gmail.com wrote:
> 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

Second time today:
SELECT keyword
FROM v$reserved_words
WHERE keyword LIKE 'NA%';

No. You can find demos of ISO and ANSI syntax equivalencies in Morgan's Library at www.psoug.org under Joins.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)