HOW TO RESOLVE THIS ISSUE

Question

HOW TO RESOLVE THIS ISSUE

Best-330874

SSCrazy

Points: 2350
More actions
December 1, 2006 at 9:26 am

#153318

Hi
   Can somebody help me to resolve this error

SELECT SUM(WaiverofPremium)
FROM GE_Claim
INNER JOIN GE_Reserve on GE_Claim.PolicyNumber = GE_Reserve.PolicyNumber
                      AND GE_Claim.TableCode = GE_Reserve.TableCode
                      AND GE_Claim.SeriesCode = GE_Reserve.SeriesCode
                      AND GE_Claim.Month_of_file = GE_Reserve.Month_of_file
WHERE (LossDate IS NOT NULL) AND (DATEADD(yyyy, 10, EffectiveDate) < LossDate) AND (Month_of_file = '20060901')

Server: Msg 209, Level 16, State 1, Line 1
Ambiguous column name 'Month_of_file'.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Bill Tifft-356596 Grasshopper Points: 13 More actions · Answer 1

I would suspect that both GE_Claim and GE_Reserve have a column named Month_of_file. Prefix the column name with the appropriate table alias and you should be okay.

Best-330874 SSCrazy Points: 2350 More actions · Answer 2

Can you explain please i dont understand it

Thanks

PW-201837 SSC-Insane Points: 20805 More actions · Answer 3

AND (Month_of_file = '20060901')

The SQL parser is telling you it doesn't know which Month_of_file you mean.

Did you mean GE_Claim.Month_of_file ?

Or did you mean GE_Reserve.Month_of_file ?