Thanks..... I got it from the reply below and adding a join to filter what I really wanted.

Thanks again!

Thanks.....this works great...I just need to do a join to another table to filter the rows I really wanted.

Thanks again... you rock!

sorry, I did not explain it very well

..... lets say column a has value 20 and columnb has value 30 many time within a...