I am trying to join two databases in an SQL query. Database A has a table with a 5 digit client number and another table with a 5 digit matter number. The other database, B, has a table with one field ...
In this excerpt from SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, John L. Viescas and Michael J. Hernandez discuss the LEFT OUTER JOIN vs. the RIGHT OUTER JOIN and offer ...