Re: Temporary table and virtual column

On Thu, 14 May 1998 12:25:14 GMT, ian@tubeway-army.demon.co.uk (Ian Clark) wrote: [snip] >SELECT field1, field2, field3 "TR" FROM table1 WHERE some_conditions1 >UNION >SELECT field1, field2, field3 "SH" FROM table1 WHERE some_conditions2 >INTO TEMP temp_table> [snip] Many thanks to those of you who replied both personally and via the newsgroup. The solution was simply to replace the above statements with the following: SELECT field1, field2, "TR" field3 FROM table1 WHERE some_conditions1 UNION SELECT field1, field2, "SH" field3 FROM table1 WHERE some_conditions2 INTO TEMP temp_table A subtle but crucial difference :) Cheers, Ian.