Simple SQL Query

From: MGZ <member_at_dbforums.com>
Date: 17 Jul 2002 07:15:10 GMT
Message-ID: <3d35197e$1_at_usenetgateway.com>


I have a table with odd column names. WHeneever I select the column I get a invalid column name. What can I do to get the query to work?

here it is

SELECT p.UWI "UWI",p.OIL-m3 "Oil",p.GAS-e3m3 "Gas",p.WATER-m3 "Water",p.COND-m3 "Condensate" FROM production p, well_info w WHERE w.LE=100;

thanks

--
Posted via dBforums
http://dbforums.com
Received on Wed Jul 17 2002 - 09:15:10 CEST

Original text of this message