Home » SQL & PL/SQL » SQL & PL/SQL » difference between Join and Inner Join
difference between Join and Inner Join [message #202299] Thu, 09 November 2006 00:47 Go to next message
selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai
Senior Member
Hi friends,

i am using following query :

what is the difference between these two quries...?

Select Count*),a.photo_id,a.album_id,b.id,b.Temp_id,b.Temp_Soln
from test_tab b join Temp_tab a
on b.id = a.album_id
Group by a.Photo_id ;

Select count(*),a.photo_id,a.album_id,b.id,b.Temp_id,b.Temp_Soln
from test_tab b,Temp_tab a
where b.id=a.Album_id

Group by a.Photo_id ;

Select Count*),a.photo_id,a.album_id,b.id,b.Temp_id,b.Temp_Soln
from test_tab b Inner join Temp_tab a
on b.id = a.album_id
Group by a.Photo_id ;

I want to know the difference between USING JOIN and INNER JOIN in quries, kindly tell me .

Thanx and Regards
Selva
Re: difference between Join and Inner Join [message #202378 is a reply to message #202299] Thu, 09 November 2006 07:22 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
well the query which you have posted i am sure that you have not tried executing it since it wouldnt work.
ohh and about the difference between inner and outer join here is what you need.

and maaher you would jus love to lock this one too..
Re: difference between Join and Inner Join [message #202411 is a reply to message #202299] Thu, 09 November 2006 11:49 Go to previous message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
The keyword "INNER" is optional for inner joins, so INENR JOIN and JOIN mean the same thing.

The pre-ANSI Oracle syntax where you list the joins in the WHERE clause is also an inner join unless you use "(+)" (outer join operator).
Previous Topic: ora-010002 fetch out of sequence.
Next Topic: rolling standard deviation
Goto Forum:
  


Current Time: Thu Dec 08 06:15:20 CST 2016

Total time taken to generate the page: 0.06018 seconds