When using query designer, what is the best way to set up joins from a master database to other databases which may or may not have matching records based on a common field. We want to query this information to a report.
Tom