topic Re: Aggregate in SELECT query in Application Development and Automation Discussions

Aggregate in SELECT query

Former Member — Tue, 29 Aug 2006 06:23:05 GMT

Hi All,

Is it possible to manipulate(add, subtract,...) two fields belonging to two different tables in a SELECT query or JOIN statement.

Ex.

SELECT

INTO TABLE

<RESULT_TAB>

FROM

INNER JOIN

<TABLE1>_{<FIELD1> = <TABLE2>}<FIELD1> ...

My problem is, while selecting can i add or subtract two fields say <TABLE1>_{<FIELD1> and <TABLE2>}<FIELD1>.

Regards,

Mustajab.

Re: Aggregate in SELECT query

dani_mn — Tue, 29 Aug 2006 06:33:51 GMT

IT is not possible directly using query.

you can do sum in 'SELECT - ENDSELECT' or after selection into internal table you can do SUM.

possible variants of SELECT are.

<b>1. fdescriptor

2. MAX( [DISTINCT] fdescriptor )

3. MIN( [DISTINCT] fdescriptor )

4. AVG( [DISTINCT] fdescriptor )

5. SUM( [DISTINCT] fdescriptor )

6. COUNT( DISTINCT fdescriptor )

7. COUNT( * )</b>

Regards,

Re: Aggregate in SELECT query

Former Member — Tue, 29 Aug 2006 06:55:57 GMT

Hi u cannot do directly within the select query ,but u can do it with SELECT-ENDSELECT and also once that data selected into an internal table and then modify the internal table.