Women in Technology

Hear us Roar



Article:
  More on JOINS
Subject:   Right outer joins in MS SQL SERVER
Date:   2002-05-01 02:13:54
From:   sanjayk
I am interested in knowing how the right outer joins work in sql server. I noticed the difference in behavior between the =* and the phrase "right outer join". The result set is different. Please go through the T-sql statements shown below.


select a.au_id, b.title, c.qty
from titleauthor a, titles b, sales c
where (a.title_id =* b.title_id)
and (a.title_id =* c.title_id)



select a.au_id, b.title, c.qty
from titleauthor a
right outer join titles b
on (a.title_id = b.title_id )
right outer join sales c
on (a.title_id = c.title_id )


The first results into 391 rows in pubs database of sql-server 2000 and the second produces 34 rows. Can you through some light on this?


Main Topics Oldest First

Showing messages 1 through 1 of 1.

  • Right outer joins in MS SQL SERVER
    2003-07-10 11:59:34  anonymous2 [View]

    The first query works as a cross join because you are not telling the system what type of join you want to use. The second one is written properly.