HOWTO: How To Create an SQL Outer Join Using the View Designer

MORE INFORMATION

1. Create a datasource to the pubs database on SQL Server.
2. Create a new remote View, and select your new datasource created in step 1.
3. Select the Authors table.
4. Click again, and select the Publishers table.
5. The join condition dialog appears showing:

   Publishers.city - Authors.city

6. Change the join condition to Right Outer Join.
7. Select the following fields from the Authors table:

   authors.au_fname
   authors.au_lname

8. Select the following field from the Publishers table:

   Publisher.pub_name

9. Run the query.