From: mcstockX@Xenquery   
      
   "Jagdip Singh Ajimal"  wrote in message   
   news:c84eb1b0.0402180225.2f8071d0@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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)