Hi,

I think that the answer is to use GROUP BY but I'm not sure.Also a sub query that calls itself with @ parameters might work but I'm also not sure it is correct or how to do this.Suggestions anyone?

Please help.

I didn't find the right solution from the Internet.

References:
http://www.sqaforums.com/forums/softwar … table.html
Pharmaceutical advertising

Thanks