SQL Outer Joins

nickstone · June 12th, 2003, 10:20 AM

Hi

I have two tables that I'm joining together using a RIGHT OUTER JOIN as below:

SELECT tbl1.RatingID, tbl4.RatingTypeID
FROM DataRating As tbl1 RIGHT OUTER JOIN
DataTypeOfRating As tbl4 ON tbl1.RatingTypeNameID = tbl4.RatingTypeID

The DataTypeOfRating Contains 16 entries and the DataRating a few thousand. I do not seem to be getting all the entries in DataTypeOfRating each time. The result set seems more like an INNER JOIN - can somebody please tell me what I'm doing wrong. I've enclosed a few entries from the result set below:

561851|1
561852|2
561853|3
561854|4
561855|5
561856|6
561857|7
561858|8
561859|9
561860|10
561861|11
561862|12
561863|13
561864|14
561866|2
561867|3
561868|4
561869|5
561870|6
561871|7
561872|8
561873|9
561874|10
561875|11
561876|12

Thanks

Nick

owain · June 20th, 2003, 10:06 AM

If you want to return all rows from one table for each row in another table, leave out the JOIN clause altogether:

Code:

SELECT tbl1.RatingID, tbl4.RatingTypeID
FROM DataRating AS tbl1, DataTypeOfRating As tbl4

This will give you a result set similar to the following:

Code:

Is that what you wanted?

Regards
Owain Williams