469,167 Members | 1,161 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

Slightly Dumb Question about JOIN

Hello All,

I'm trying to find out exactly what JOIN does

eg.

SELECT A.Name
FROM Author A JOIN Publisher P
ON A.SomeID = P.SomeID
WHERE P.Country = 'X'

I know what inner, outer, right and left joins do, but what does just
JOIN on its own do? (Can't find it in help either)

Thanks,

K Finegan
Jul 20 '05 #1
3 1435
The JOIN keyword with no type qualifier implies an inner join. A left or
right join implies left or right OUTER joins.

HTH

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #2


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #3

Hi

This is details in Books online under the From clause documentation

INNER

Specifies all matching pairs of rows are returned. Discards unmatched
rows from both tables. This is the default if no join type is specified.
http://msdn.microsoft.com/library/de.../en-us/tsqlref
/ts_fa-fz_4ox9.asp?frame=true
John
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Heiko Wundram | last post: by
4 posts views Thread by Python Dunce | last post: by
3 posts views Thread by Chris Petersen | last post: by
4 posts views Thread by Laszlo Zsolt Nagy | last post: by
375 posts views Thread by rkusenet | last post: by
9 posts views Thread by Bob Stearns | last post: by
16 posts views Thread by CMM | last post: by
3 posts views Thread by Michiel Overtoom | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.