I am performing a Select command on a cursor and wish the result to be sent to the same cursor. This is fine if it is a single select statement but if i perform a union within the statement it wont allow me to use the cursor twice and comes up with an open table dialogue box. I have tried sending the result to a different cursor and then after the search has finished sending it back to the origanal one but then i get an error saying " table must be created using select into table"

If anyone got any ideas on this I would be grateful for a reply

Thankyou in advance