MySQL

Get customers_info_date_account_created

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jan 2008

Posts: 16

Reputation: BillyMako is an unknown quantity at this point

Solved Threads: 0

BillyMako

Offline

Newbie Poster

Get customers_info_date_account_created

Dec 3rd, 2008

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:

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT *
FROM customers
WHERE customers_id NOT
IN(
   SELECT customers_id
   FROM orders
)
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'

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.