UtterAccess HomeUtterAccess Wiki

Welcome Guest ( Log In | Register )

Custom Search
Edit Discussion
> Merging Multiple Queries    
Merging Multiple Queries

Image:NotifCleanup.gif This page requires general cleanup in formatting or text to better fit the UA Wiki Guidelines
This page is a stub. Please help us by expanding or merging it with applicable content

Article Information
Accompanying File(s)

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

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

Edit Discussion
Custom Search
Thank you for your support!
This page has been accessed 4,387 times.  This page was last modified 02:26, 10 February 2012 by Jack Leach. Contributions by Cpetermann  Disclaimers