Skip to Content
avatar image
Former Member

Create Derived Table

Hi people

i have query & i need to make a Derived table

& every time i try to create this table i get the same error

"each calculated column must have explicit name"

i tried as & explicit name for the calculated column & i still get the same error

here is the query as i run it in Toad without any changes

(

select A.ACCT_NO,

a.description,

CRNCY.ISO_CODE,

sum(b.cur_bal) cur

from

AD_GB_CRNCY CRNCY,

gl_balances b,

gl_acct a

where

b.GL_ACCT_ID = a.GL_ACCT_ID

and b.CRNCY_ID = crncy.CRNCY_ID

and a.ledger_no in

(select distinct substr(WIP_ACCT_NO,17,13) wp

from

AD_GB_ACCT_TYPE

where DEP_LOAN = 'LN' and acct_type != '196')

group by

A.ACCT_NO,CRNCY.ISO_CODE

,a.description

having sum(b.cur_bal) !=0 order by A.ACCT_NO,CRNCY.ISO_CODE;

)

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 24, 2017 at 10:09 AM

    change below part in your sql and try.

    (select distinct substr(WIP_ACCT_NO,17,13) as wp

    Add comment
    10|10000 characters needed characters exceeded