Right Join with a not null

I am trying to write a query to capture all the records from the table
HistoricalEvents_URLS that are not null for the field
HistoricalEvents_Urls.articlerating. I also want to pull any matching
records from the MasterSocietalData. Is what I wrote below correct?



Select A.*,B.ArticleRating From MasterSocietalData as A Right Join
HistoricalEvents_URLS as B On A.Item = B.DocItemID and B.EventID
=:HistoricalEventID and B.ArticleRating is not null

"Mark Clark" <mcmahling@mac.com> wrote in message news:401b1dba@wic040d....
> I am trying to write a query to capture all the records from the table
> HistoricalEvents_URLS that are not null for the field
> HistoricalEvents_Urls.articlerating. I also want to pull any matching
> records from the MasterSocietalData. Is what I wrote below correct?
>
>
>
> Select A.*,B.ArticleRating From MasterSocietalData as A Right Join
> HistoricalEvents_URLS as B On A.Item = B.DocItemID and B.EventID
> =:HistoricalEventID and B.ArticleRating is not null

No, not quite. A right join here means show data from all rows in
HistoricalEvents_URLS but show only data from the MasterSocietalData rows,
which have a match in HistoricalEvents_URLS - based on the join condition. I
think what you want is something like this:

Select A.*, B.ArticleRating
From MasterSocietalData as A
Left Join
HistoricalEvents_URLS as B
On A.Item = B.DocItemID
Where
B.EventID = :HistoricalEventID
and B.ArticleRating is not null;

IHTH

- Per