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 (BOB member since 2011-01-12)