Get customers_info_date_account_created
 

I need to get the 'customers_info_date_account_created' from the 'customers_info' table where the field 'customers_info_id' matches with the field 'customers_id' in the following query:

SELECT *

FROM customers

WHERE customers_id NOT

IN(

   SELECT customers_id

   FROM orders

)

I basically have all the information in columns from the query and need an extra field which has the 'customers_info_date_account_created' which is related to the 'customers_id'

Re: Get customers_info_date_account_created
 

Here is a diagramn explaining what i need to do.