On 2/24/2015 8:42 PM, russ lyttle wrote: > The 'a' table defines spaces to be controlled, the 'b' tables the > control schedules and parameters. > It would not be unreasonable to assume the 'a' table has >100 rows. > Each row in the 'a' table is associated with 3 'b' tables, all the names > known in advance and created off line at the same time as the row in the > 'a' table. > Each 'b' table has up to 1,440 rows.
Replace these three tables with a single table, holding three times as many rows. It would have an extra column holding the "original source" indicator - a value that indicates which of the three tables this row originated from. Now, in table "a" store this indicator where you planned to store the table name. -- Igor Tandetnik