Problem with nested select

[Former Member]

I have a problem setting select structure to calculate the total days from a table .The problem is like that:

I have 2 tables first of which contains 'days' and 'objnr3' fields.objnr3 contains the id's of elements with stufe = 3.

The latter table contains 'objnr2' and 'objnr3' fields but not 'days' and I want to calculate the total days spent on the jobs with stufe = 2 using SELECT SUM(days)....

What should I do to have it calculated?

Edit : The latter table is an internal table, not an SQL one and this makes the problem complicated for a beginner .

Thanks in advance..

[Former Member]

HI

First make a loop on inetrnal table and store all entries with stufe = 2 on another internal table.

neaxt make select query of DB table using all entries and then sum up the days.

Aditya

[Former Member]

Hi Andy,

Write query like this

SELECT SUM(days) as days objnr2 objnr3........................

Check this,

Regards,

Santosh Kumar M.