nearly. i think this is what im after, need to test later.

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 IS NULL AND
customers_info.customers_info_date_account_created BETWEEN (NOW() - INTERVAL 14 DAY) AND (NOW() - INTERVAL 7 DAY)

thanks for the pointers :)