Re: [Q] Another SQL question???

In <47qglg$g02@tin.monsanto.com> Saqib Mausoof <ssmaus@musctn.monsanto.com> writes: > >You guys have been extremely helpful, so I will have another go at this >;-) > >I have constructed the following query with the help of Net God(esses). > >select col1, col2, col3 from table1 where col1="xyz" >union >select col1, col2, col3 from table2 where col1="xyz" >into temp temp_table;> >select temp_table.col1, temp_table.col2, temp_table.col3, table3.col1 >from temp_table, table3 >where temp_table.col3=table3.col1> >This works fine, except the data in table3 is being continuosly updated >so I need to run this query repeatedly. That is not a problem EXCEPT, >once a TEMP table temp_table has been created, Informix gives an error >saying that the table still exists. ANY way around that???? > Saqid: you must be using the standard engine. We have had probelms dropping temp tables with standard engine so we have taken to deleting all the rows from the temp table instead of re-creating it. Now, with the online engine you don't have a problem dropping temp tables. regards, ed schaefer