append a table onto the end of another

I have two tables, appointments and backupappointments. I also have a
function getAppointments(theDate DATE) RETURN RECORDSET (which has not been written yet).
What I want the function to do is take a date, and return a table of appointments on that date. My problem has two parts:

1. How do I append the table backupappointments to the table appointments so that I can do a simple SELECT on the date of this new table?
2. How do I return the filtered table?

Any help would be greatly appriciated

Jagdip Singh Ajimal Received on Wed Feb 18 2004 - 04:25:38 CST