please see below, the date field im after is customers_info_date_account_created. I want to only return results for the current given month.


SELECT c.*, ci.*
FROM customers c
LEFT JOIN customers_info ci on c.customers_id = ci.customers_id
WHERE c.customers_id = ci.customers_id
AND ci.customers_info_date_account_created