Re: append a table onto the end of another

From: Seamus Ma' Cleriec <zawadzki_at_yahoo.com>
Date: 18 Feb 2004 08:21:18 -0800
Message-ID: <1720ec78.0402180821.5cdd8535_at_posting.google.com>


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 - 17:21:18 CET

Original text of this message