How would I make a Union Query out of these two simple tables?

  • Thread starter Thread starter Bayou BoB
  • Start date Start date
B

Bayou BoB

I would like to make a union query out of these two tables. How would
I go about this? I made an attempt and failed badly! Many thanks.

tbl1
-MedSchedule (name)
MedSchedID
ActDate
Activity
Destination
StaffName
ClientName
Notes

tbl2
-ProgSchedule(name)
ProgSchedID
ActDate
Activity
Destination
StaffName


Many thanks!

K
 
SELECT
MedSchedID,
ActDate,
Activity,
Destination,
StaffName,
ClientName,
Notes
FROM MedSchedule
UNION ALL
SELECT
ProgSchedID,
ActDate,
Activity,
Destination,
StaffName,
Null,
Null,
FROM ProgSchedule;
 
I don't think this would work since it looks like tbl1 and tbl2 don't have
the same number of fields.
 
Back
Top