Simple SQL Query
From: MGZ <member_at_dbforums.com>
Date: 17 Jul 2002 07:15:10 GMT
Message-ID: <3d35197e$1_at_usenetgateway.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.comReceived on Wed Jul 17 2002 - 09:15:10 CEST