Re: Temporary table and virtual column

This is a multipart message in MIME format --------------InterScan_NT_MIME_Boundary Content-Type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable Ian, Field labels come AFTER the text, as in SELECT "BLAH" field1 =2E=2E=2E=2E not SELECT field1 "BLAH" =2E=2E=2E=2E HTH Davin ______________________________ Reply Separator ____________________________= _____ Subject: Temporary table and virtual column Author: PC {ian@tubeway-army=2Edemon=2Eco=2Euk} at INTERNET Date: 14/05/1998 15:41 Hi All, =20 Take a look at the following statements written into a 4GL program: =20 SELECT field1, field2, "TR" FROM table1 WHERE some_conditions1=20 UNION SELECT field1, field2, "SH" FROM table1 WHERE some_conditions2=20 INTO TEMP temp_table =20This doesn't go down to well with the compiler since the virtual=20 column of static values I want to insert cannot be achieved unless I=20 somehow have a column name too=2E Replacing the above with this; =20 SELECT field1, field2, field3 "TR" FROM table1 WHERE some_conditions1=20 UNION SELECT field1, field2, field3 "SH" FROM table1 WHERE some_conditions2=20 INTO TEMP temp_table =20yields more error messages=2E I am not sure where to go from here=2E For=20 simplicity I would like to perform the SELECT and creation of the=20 temporary table in one go but if I can't, how can I achieve what I=20 want=2E =20 Any help would be very much appreciated=2E =20 Cheers, Ian=2E =20 ********************************************************************** DST International Tel:+44 181 390 5000 www=2Edstinternational=2Eco=2Eu= k=20 This message and any attachments to it is intended only for the=20 individual or company to which it is addressed and may contain=20 information which is privileged, confidential or prohibited from=20 disclosure or unauthorised use=2E If the recipient of this=20 transmission is not the intended recipient, or the employee or agent=20 responsible for delivering such materials to the intended recipient,=20 you are hereby notified that any use, any form of reproduction,=20 dissemination, copying, disclosure, modification, distribution and/or=20 publication of this e-mail message or its attachments other than by=20 its intended recipient is strictly prohibited by the sender=2E =20 If you have received it in error, please notify us immediately by=20 telephone on the number above and destroy the message and all copies=20 in your possession=2E ********************************************************************** --------------InterScan_NT_MIME_Boundary--