This page requires general cleanup in formatting or text to better fit the UA Wiki Guidelines

Developers often start out by creating individual queries and then joining them to form a final query to return the result they want.
As they get better at SQL writing they realize that they could have written those queries into one query instead. Although they know that the queries can be merged into one query, they don’t know how to do that.

As such, this Access 2003 video tutorial shows a very simple technique on how to merge multiple queries into one query to reduce the amount of queries in your database.
You can download the video Merge Multiple Queries

After you download the video and extract it from the zip file open the file called: Merging Multiple Queries Into One Query.htm

Note: This tutorial should not replace the knowledge a developer should acquire in trying to write queries from scratch and incorporating everything into one.
But it acts more as a techinque to assist in the interim while the developer skills improve.

This page was originally ported from the UtterAccess Forums. It is based heavily or in part on a post by dallr.
Merging Multiple Queries