Re: Substitution of column names

From: Ansgar Seiter <seiter_at_phya5.physik.uni-freiburg.de>
Date: 1997/02/17
Message-ID: <33088C57.41C6@phya5.physik.uni-freiburg.de>#1/1

Dear Maureen,

I know, people who post a question want an answer to it rather than being fed some pedagogical input. So let me put it as a question : Is there a strong reason for using this peculiar table structure ? Life could be perhaps easier if your table would look like this :

        FUND
        ORGN
        ACCT
        TOTAL
        MONTH

with Month ranging from 1-12.
Now your select would look like :

        SELECT FUND, ORGN, ACCT, TOTAL
         FROM MYTABLE
        WHERE MONTH = nn;

Sorry,

-- 
 Ansgar Seiter          	 Group Prof. Ch. Schlier      
 Department of Physics  	                             
 University of Freiburg 	 Phone:  +49 761 203-5730      
 Hermann-Herder-Str. 3  	 FAX:    +49 761 203-5873            
 D-79104 Freiburg i.Br  	 E-Mail: seiter_at_phya3.physik.uni-freiburg.de 
 Germany

Received on Mon Feb 17 1997 - 00:00:00 CST