Print Page | Close Window

SubQueryInFROM.mdb ( beginner )

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=259
Printed Date: 28 Mar 2024 at 1:00pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: SubQueryInFROM.mdb ( beginner )
Posted By: Roger Carlson
Subject: SubQueryInFROM.mdb ( beginner )
Date Posted: 21 Jul 2008 at 10:38pm
 
Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - find out why here .
 
SubQueryInFROM.mdb
 
Demonstrates how to use a subquery in the FROM clause of a query. There is a seriously weird, undocumented format for using a subquery in the From clause - essentially as another table. It won't work if you have spaces or special characters in the names of tables or fields (which I don't like anyway). Because of the syntax, *this* sort of subquery cannot itself contain a subquery of the same format. The syntax is: [insert your query here]. As SomeAlias The left and right square brackets are required, the dot after the right bracket is required, and the As and alias are required. You can't do ANYTHING that would require the use of square brackets, inside the square brackets - that's why no spaces or special characters in names. **Thanks to Don Edwards for sharing this**
 
Download
Access 2000 (24 KB):
http://www.rogersaccesslibrary.com/forum/uploads/5/SubQueryInFROM2k.zip - uploads/5/SubQueryInFROM2k.zip


-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net