December 1, 2006 at 10:18 am
Hi,
Please can somebody help me with this query
I have two tables
1. GE_Claim------------- Column names are as follow ( PolicyNumber,TableCode,SeriesCode,Month_of_file,DateLoss,EffectiveDate)
2. GE_Reserve----------- Column names are as follow ( PolicyNumber,TableCode,SeriesCode,Month_of_file,WaiverofPremium)
Condition is as follows
Query when run shoul pull only distinct/unique record
WHERE (LossDate IS NOT NULL) AND (DATEADD(yyyy, 10, EffectiveDate) < LossDate)
What i want to do is when i run this query i will use Month_of_file and it will give me the result set for "WaiverofPremium" for only that month.i guess
an INNER JOIN is required because (DateLoss,EffectiveDate are in table GE_Claim) and (WaiverofPremium in table GE_Reserve) but i dont know how to use it.
December 1, 2006 at 10:43 am
Try looking at this page and passing more information... It is difficult to know what someone is getting and what they want to retrieve without some data, code, etc. Help us help you
I wasn't born stupid - I had to study.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply