I am after some SQL code for Oracle Discoverer.....which does the following sequence of steps:
1. Run a SQL Code to pull data back from tables A, b and c (staff details)
2. then append this data to a master table.
2. then repeat step 1, with a slight change in SQL criteria and append the results back to step 2 the master table..
so each time I change the selection criteria I want the end result to end up in the master table.