0

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'

1
Contributor
1
Reply
2
Views
9 Years
Discussion Span
Last Post by BillyMako
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.