Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

When you execute a query using the RIGHT JOIN syntax, SQL does two things: It returns all of the records from both tables that contain matching values, as defined by the ON clause.

Hopefully someone has a little experience with this. <BR><BR>Here is the setup:<BR>I've got an old access database that stores purchasing information from a system we used for the past 10 years.