Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Location
    Calgary, Canada
    Posts
    30

    Unanswered: Simple Select Statement

    I have a table with some odd column names. I cannot select from it normally without getting an invalid column name. How do I select the rows?

    Here is my query.

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Calgary, Canada
    Posts
    30
    nm I figured it out. I should have been more persistant before posting.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •