amerar_at_iwc.net wrote:
> 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!!
My first thought is SELECT DISTINCT but it would seem from what little
you have provided that each person can have one, and only one, email
address so please define DISTINCT as you are using it.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Mar 06 2007 - 13:04:36 CST
