Help with DISTINCT

From: <amerar_at_iwc.net>
Date: 6 Mar 2007 10:53:21 -0800
Message-ID: <1173207200.978361.104720@30g2000cwc.googlegroups.com>

Hi All,

I have this log-assed query. I need to make it such that I am getting a distinct EMAIL value for that column. I'm not sure how to do that with this query......it has no group by or anything...

select

   cv.First_name,
   cv.Last_name,
   cv.email,

   p.name as Product,
   cp.Date_Entered as "Start Date",
   cp.exp_date as "Expiration Date",
   (cp.QUANTITY * p.base_price) as "Amount $" from customer_product cp, customer_visitor cv, product p, TEMP_ADID_1 t

where cp.customer_id = t.customer_id
  and cp.Date_Entered >= to_date('01.01.2000','mm/dd/rrrr')
  and cp.Date_Entered < to_date('02.02.2007','mm/dd/rrrr')
  and cp.customer_visitor_id = cv.customer_visitor_id
  and cp.PRODUST_ID = p.PRODUST_ID;

Thanks in advance!! Received on Tue Mar 06 2007 - 12:53:21 CST