UNION Query syntax Issue (1 Viewer)
- Thread starter Buxtona
- Start date
Tried it with these brackets:
SELECT wj_attendance.ShopID
FROM wj_attendance
WHERE (wj_attendance.EmployeeID=3372) AND (wj_attendance.SerialDate Between 20160101 And 20191016)
UNION
SELECT wj_attendance2017.ShopiD
FROM wj_attendance2017
WHERE (wj_attendance2017.EmployeeID=3372) AND (wj_attendance2017.SerialDate Between 20160101 And 20191016)
UNION
SELECT wj_attendance2016.ShopID
FROM wj_attendance2016
WHERE (wj_attendance2016.EmployeeID=3372) AND (wj_attendance2016.SerialDate Between 20160101 And 20191016)
Same error message.
SELECT wj_attendance.ShopID
FROM wj_attendance
WHERE (wj_attendance.EmployeeID=3372) AND (wj_attendance.SerialDate Between 20160101 And 20191016)
UNION
SELECT wj_attendance2017.ShopiD
FROM wj_attendance2017
WHERE (wj_attendance2017.EmployeeID=3372) AND (wj_attendance2017.SerialDate Between 20160101 And 20191016)
UNION
SELECT wj_attendance2016.ShopID
FROM wj_attendance2016
WHERE (wj_attendance2016.EmployeeID=3372) AND (wj_attendance2016.SerialDate Between 20160101 And 20191016)
Same error message.
and silly thing is:
SELECT wj_attendance.ShopID
FROM wj_attendance
WHERE (wj_attendance.EmployeeID=3372) AND (wj_attendance.SerialDate Between 20160101 And 20191016)
UNION
SELECT wj_attendance2017.ShopiD
FROM wj_attendance2017
WHERE (wj_attendance2017.EmployeeID=3372) AND (wj_attendance2017.SerialDate Between 20160101 And 20191016)
If i only combine 2 tables it works
SELECT wj_attendance.ShopID
FROM wj_attendance
WHERE (wj_attendance.EmployeeID=3372) AND (wj_attendance.SerialDate Between 20160101 And 20191016)
UNION
SELECT wj_attendance2017.ShopiD
FROM wj_attendance2017
WHERE (wj_attendance2017.EmployeeID=3372) AND (wj_attendance2017.SerialDate Between 20160101 And 20191016)
If i only combine 2 tables it works
isladogs
MVP / VIP
- Local time
- Today, 13:24
- Joined
- Jan 14, 2017
- Messages
- 18,207
Are there any results for the 2016 table using the WHERE filter if its run on its own?
What happens if you do this in 2 stages?
1. Create qryUnion with no filters
2. Create another query filtering qryUnion
Also, as possibly implied in post #1 table is the plan to combine all 3 tables into one?
What happens if you do this in 2 stages?
1. Create qryUnion with no filters
2. Create another query filtering qryUnion
Also, as possibly implied in post #1 table is the plan to combine all 3 tables into one?
All 3 queries run ok on their own
Gasman
Enthusiastic Amateur
- Local time
- Today, 13:24
- Joined
- Sep 21, 2011
- Messages
- 14,217
yes i want to join all three tables to get results from all 3 years
