How To Create an SQL Outer Join Using the View DesignerLast reviewed: October 18, 1996Article ID: Q151797 |
The information in this article applies to:
SUMMARYThis article explains how to create an outer join on a SQL Server table using the Remote View Designer. An outer join is necessary if the View needs to display not only matching rows between tables (rows with values in the specified columns that satisfy the join condition), but also non- matching rows. An outer join can only be performed if the backend DBMS supports it. This article uses the pubs database in Microsoft SQL Server.
MORE INFORMATIONThis query uses the Authors table and the Publishers table and shows not only authors who have publishers in the same city, but also authors without publishers in the same city.
REFERENCES"SQL Server Database Developers Companion", and "Visual FoxPro Developer's Guide."
|
Additional reference words: 3.00 3.00b VFoxWin
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |