I'm useing sybase and the OVER PARTITION option didn't seem to work...

However I thought about and realized that primarily i really just want to remove from the master list, any instance where the user has a "1"...

thus I did a select * from that list i gave... so it returned combinations of zero and ones... but then i simply did an NOT in (select * from that same list)

So basically i removed the id's via the NOT IN option.

That said, I was moved off the project :-/ It was the final task that had been given to me....

Thanks for the replies... though feel free to keep replying in case others might ever run into a similar situation...