943,640 Members | Top Members by Rank

Ad:
  • MySQL Discussion Thread
  • Marked Solved
  • Views: 545
  • MySQL RSS
Dec 3rd, 2008
0

Get customers_info_date_account_created

Expand Post »
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:

sql Syntax (Toggle Plain Text)
  1. SELECT *
  2. FROM customers
  3. WHERE customers_id NOT
  4. IN(
  5. SELECT customers_id
  6. FROM orders
  7. )

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'
Last edited by peter_budo; Dec 3rd, 2008 at 7:13 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
BillyMako is offline Offline
16 posts
since Jan 2008
Dec 3rd, 2008
0

Re: Get customers_info_date_account_created

Here is a diagramn explaining what i need to do.
Attached Thumbnails
Click image for larger version

Name:	ex1.jpg
Views:	10
Size:	197.6 KB
ID:	8430  
Reputation Points: 10
Solved Threads: 0
Newbie Poster
BillyMako is offline Offline
16 posts
since Jan 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: run the multiple select statement
Next Thread in MySQL Forum Timeline: how to update data in mysql table using data from an excel table





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC