I have a shopper table, and an orders table.

so when they join they create lots of duplicate shopper records in the result set (cuz they multiply with each order > 1)

and i would like a cross tab graph that plots out ShopperType1 vs ShopperType2 obviously this plots false numbers because it is counting duplicate shoppers (because of the join to the order table)

how do i get around this?