Group By Clause - Oracle SQL
All,

I have to display about 5 columns from 2 database tables using the Group By clause as follows:

    SELECT T1.COLUMN_A, T1.COLUMN_B, T1.COLUMN_C, SUM(T2.COLUMN_D)
    FROM TABLE1 T1, TABLE2 T2
    WHERE T1.COLUMN_A = T2.COLUMN_A
    GROUP BY T1.COLUMN_A

Now COLUMN_B has the same value across all the rows having the same COLUMN_A and COLUMN_B is a amount field.
COLUMN_C is a date field and would be same across the same COLUMN_A values.

Ex. Here is dummy data TABLE T1

    COLUMN_A           COLUMN_B          COLUMN_C
    1                    $25               09/15/2911 12:00:00 AM
    1                    $25               09/15/2011 12:00:00 AM
    2                    $20               12/12/2011 12:00:00 AM
    ...

TABLE T2:

    COLUMN_A       COLUMN_D
    1                $100
    1                $10
    2                $200
    2                $200
    .....

Running the query does not work with following error: `ORA-00979: not a GROUP BY expression`

Removing COLUMN_B and COLUMN_C would work. However I need these columns as well.

Can anyone please suggest the required changed?
Group By Clause - Oracle SQL
===

All,

I have to display about 5 columns from 2 database tables using the Group By clause as follows:

    SELECT T1.COLUMN_A, T1.COLUMN_B, T1.COLUMN_C, SUM(T2.COLUMN_D)
    FROM TABLE1 T1, TABLE2 T2
    WHERE T1.COLUMN_A = T2.COLUMN_A
    GROUP BY T1.COLUMN_A

Now COLUMN_B has the same value across all the rows having the same COLUMN_A and COLUMN_B is a amount field.
COLUMN_C is a date field and would be same across the same COLUMN_A values.

Ex. Here is dummy data TABLE T1

    COLUMN_A           COLUMN_B          COLUMN_C
    1                    $25               09/15/2911 12:00:00 AM
    1                    $25               09/15/2011 12:00:00 AM
    2                    $20               12/12/2011 12:00:00 AM
    ...

TABLE T2:

    COLUMN_A       COLUMN_D
    1                $100
    1                $10
    2                $200
    2                $200
    .....

Running the query does not work with following error: `ORA-00979: not a GROUP BY expression`

Removing COLUMN_B and COLUMN_C would work. However I need these columns as well.

Can anyone please suggest the required changed?