I have 2 tables with related data.
one table is for products. and the other price. In price table one product may appear several times. 
How can I return the result showing the products without containing duplicate rows

My Query is 

```
select             p.Product, sum(p.Qty), max(pr.netprice)
from               Products  p
  left outer join  Price pr
  on               p.Product=pr.Product
where              p.brand=''
group by           p.Product,pr.Product

```

but return more rows as right table have multiple records 

please help