Something like this.

Resp_Id Brand Oc

1002 0 1

1002 ...

Thanks,

First i'll like start by getting to see the occurrences as explained for each brand a resp_Id has.

Hi,

Thanks a lot. All approaches worked well

Hi, thank you for the replies.

They all worked, i'm so grateful.

Thanks, actually copied the wrong one since i have been writing different ones. But i think the full outer join worked (though it will another problem to report a single...

Hi,

Thanks for your reply, I'll try Intersect and except since i have already tried full outer join and it didn't look to work since there are two columns where all...