SQL help needed

Given the following table (customers with payment on a certain day)

 CREATE TABLE tbl
 (

    CustNo	NUMBER,
    Day		DATE,
    Amount	NUMBER

Is it then possible to create a view, which shows ...

• vertically: the customers
• horizontal: the sum of the amounts for one month

So one row should give one customer with 12 fields 'Jan97', 'Feb97', ... giving the totaled amount for that month.

Michael G. Schneider

mgs_software_at_compuserve.com Received on Sun Nov 02 1997 - 00:00:00 CST