Member Avatar for 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'

  • 1 Contributor
  • 1 Reply
  • 127 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by BillyMako
Member Avatar for BillyMako

Here is a diagramn explaining what i need to do.

ex1.jpg 197.62 KB
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.