Re: append a table onto the end of another

jsa1981_at_hotmail.com (Jagdip Singh Ajimal) wrote in message news:<c84eb1b0.0402180225.2f8071d0_at_posting.google.com>...
> 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

1. Create a view usin the UNION of both tables
2. return a "REF CURSOR"

details left as an exercise for the reader. Received on Wed Feb 18 2004 - 10:21:18 CST