[SOLVED] Get customers_info_date_account_created

[BillyMako]

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'

 

[dclamp]

Im not really sure if there was a question in there, or you just telling us random things...

[BillyMako]

The date i need to get is in the 'customers_info' table and i need to get it using the customers_id which i get from the following querry:

 

SELECT *

FROM customers

WHERE customers_id NOT

IN(

SELECT customers_id

FROM orders

)

[BillyMako]

Here is a diagram explaining what i need to do.

 

[fenway]

NOT IN? Use a left join instead.