select VNUmber, FullName, count(ShipTo)
from tCustomer
--# where VNumber = "10000285"
--# and Shipto = "CWT"
group by VNumber, FullName
having count(ShipTo) > 1
order by 1
