here're the ddls & sample data for the 3 tables...salvatore - now you just have to explain what results you're looking for:

create table ACW_SCORE

(AUDIT_DTE smalldatetime,

ASPECT_ID int,

ACWPct decimal(7,1),

ATT decimal(7,1))

insert into...

John - what is the query ?! It appears that you are getting a syntax error...if you post the query it would help !

Salvatore - what Farrell is asking for is the results that you get from the query that you posted at the beginning of this thread...also the results that you actually...

glad you got it working Chris - would you mind posting the modified version ?!

Hear! Hear! sswords...that was brilliant! (sounds of applause!)...

here after you won't hear from me again on this post!

No - I think this is a case of outer joins...

it would help if we had the ddls of the 3 tables, some sample data and required output!

Jesper - I knew it was only a matter of time! Thanks again for yet another lesson!

this is neither here nor there but I hear tell that Mike is HERE & the only possibility of meeting her again is in the hereafter...

Here's one way....(from what I can understand the # of sectors shouldn't really matter) - it's only the quoteid and country that is being checked...

let me know if this is...

oh good! glad it worked!

Fighting.. ?????

No one's fighting - or even arguing...just having some "play on words" fun is all....

...outlook on the afterlife.....

a topic "hereafter" banned because of the nature of the inflammatory content for those of us who can have dirt dug up on us....

anytime Jeff!

"any day on this side of the dirt is a good one".....

well said rudy! you've definitely struck pay dirt with this one...

select * from organization o

inner join

hrl h

on

o.organization_id = h.organization_id

where o.name like 'delphi%'