Replacing UNION Query Parts With Queries Names (1 Viewer)
- Thread starter Jonny
- Start date
- Local time
- Today, 08:59
- Joined
- Feb 19, 2013
- Messages
- 16,610
1. no - although you can reference a query e.g.
SELECT * FROM qry1
UNION SELECT * FROM qry2
number of columns and datatype would need to be the same in both queries
2. In Access sql, no, but you can in TSQL and some other variants
SELECT * FROM qry1
UNION SELECT * FROM qry2
number of columns and datatype would need to be the same in both queries
2. In Access sql, no, but you can in TSQL and some other variants
Tried that and got an error alert.
Thank you , that helps.
I meant to "got an error" in positive meaning. The explained error is always preferred than unpredictable result.
Dreamweaver
Well-known member
- Local time
- Today, 08:59
- Joined
- Nov 28, 2005
- Messages
- 2,466
One thing I would like to add to this topic is that BOTH sides of a UNION query can have there own WHERE Clause
Like
This is used in the schedule calendar of my Employees Example Here:
https://www.access-programmers.co.uk/forums/showpost.php?p=1623602
Like
Code:
StrYE = "SELECT * From QryYearlyEventsAll WHERE [EventMonth]=" & F!Cmonth & " UNION SELECT * FROM QryYearlyEvents WHERE (([EventMonth]=" & F!Cmonth & " AND [EmployeeID]=" & E & "))"This is used in the schedule calendar of my Employees Example Here:
https://www.access-programmers.co.uk/forums/showpost.php?p=1623602
- Local time
- Today, 03:59
- Joined
- Feb 19, 2002
- Messages
- 43,266
Union and Union All produce different results. Make sure you know what you want. Most of the time it will be Union.
