Column Ambiguously Defined

Hi I am trying to create a Derived Table but getting this error,

Column Ambiguously defined…

Rest of my Derived tables are working fine & parsed…

Below is my Query (Code),

select x1.a01 AS Company_Code,

x1.b01 AS Company_Name,Y.A02 AS Branch_Code, y.b01 AS Branch_Name,

a.b31 AS Claim_No,b.c01 AS Risk_Class,

z.a02 AS This_System,

b.c01 AS Risk_Class, sum(b.k01) AS Total_Sum_Insured, sum(b.k23) AS Gross_Total_Estimate, sum(b.k24) AS Gross_Current_Outstanding,

sum(nvl(b.k25,0)+nvl(b.k26,0)) AS Gross_Paid_ToDate, sum(nvl(b.k27,0)+nvl(b.k28,0)) AS Gross_Recoveries_ToDate, count(*) AS Cnt,

a.f03 AS Agent_Code,a.f02 AS Agent_Name

from ab.ab201 a, ab.ab202 b, x.x100 x1, x.x200 y, x.x000 z

group by

a.a01,a.a02,a.b31,b.c01,x1.a01,y.a01,y.a02,

x1.b01, y.b01, z.a02 ,

b.c01,a.f03,a.f02

order by b.c01, a.f03

Any Help Appreciated…

Regards,
Chaitanya


chaitanyabhure :india: (BOB member since 2011-01-12)

Resolved…

I checked my query properly…Risk_Class got repeated twice…

Thank you in advance,
Chaitanya


chaitanyabhure :india: (BOB member since 2011-01-12)