Slightly Dumb Question about JOIN

[K Finegan]

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

[Ray Higdon]

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!

[Kevin Finegan]

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

[John Bell]

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!