| top 50 works great =) i'm used to mysql. i'm using mssql for this project though, and i did not know that.
Distinct however doesn't work for this one.
i think i will have to query the product in while iterating through the results of what my first query generates.
__________________
Mike |