Hello,
What I want to do is as follows
I have Table1 with 100 records.
Query1 contains 20 reocrds from Table1 which fuifill conditions mentioned in Query1
Query2 contains other 20records from Table1 which fulfills conditions mentioned in Query2
Records in Query1 and Query2 will always be different.
Now I want to combine Query1 & Query2 as new Table2
Table2 will now contain 20+20 = 40 records.
Some more records will be added to Table2 and used for generating further queries.
How to go about this.
Please help me.