| difference between Join and Inner Join [message #202299] |
Thu, 09 November 2006 00:47  |
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  |
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..
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
