> I thought I had figured out a way to display some info but then realized
> that I was missing something. I have a table called email_results that
> keeps track of products that users click on from an email they received.
>
>
> In this table I have a unique ID that matches them up to their email
> address and company name that is stored in another table called
> email_blast.
>
> If a person clicks on the same product twice a new row is added to the
> email_results table that includes identical data. When displaying the
> data if the same person clicked on a product more than once I only want
> to show it one time, if that same person clicked on 2 separate products
> I want to show each product they clicked on.
>
> I thought by grouping by email address that I fixed the problem but then
> noticed it will only show them as clicking on one product even if they
> clicked on 2 different products.
SELECT DISTINCT *
FROM email_results NATURAL JOIN email_blast
Jochem
--
Who needs virtual reality
if you can just dream?
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
