Re: append a table onto the end of another

"Jagdip Singh Ajimal" <jsa1981_at_hotmail.com> 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

lookup UNION (SQL) and REF CURSOR or pipeline functions or TABLE(CAST (see my posts on 'example: PIPELINED function' and 'Input array string')

• mcs