Quote Originally Posted by philip937 View Post
The query I need wants to select customers that haven't made a purchase and group by date based on when they signed up. Basically the two elements I posted earlier in this thread need to be combined with another join statement?


Code:
Select
  customers_info.customers_info_date_account_created,
  customers.customers_lastname,
  customers.customers_firstname,
  orders.date_purchased
From
  customers_info Inner Join
  customers On customers_info.customers_info_id = customers.customers_id
  Inner Join
  orders On orders.customers_id = customers.customers_id
Where
  orders.date_purchased <= Date(Date_Sub(Now(), Interval 14 Day)) And
  customers_info.customers_info_date_account_created <= Date(Date_Sub(Now(),
  Interval 14 Day))
Group By
  customers_info.customers_info_date_account_created