Courtney,
>SELECT consumers.id FROM consumers
>WHERE date_of_birth = ? AND consumer.id =
>(SELECT consumer_id FROM cases WHERE last_name = ?
>AND full_first_name = ? )
>Is there a way to form the above statement in MYSQL?
Something like this would be faster ...
SELECT co.id
FROM c
:31 AM
To: mysql@lists.mysql.com
Subject: Connecting to queries into one
MY GOAL
To collect any consumers.id WHERE date of birth, last
name and
first name matches what was entered by the user. The trick is that
date of birth lives in the consumer
, February 27, 2006 1:31 PM
To: mysql@lists.mysql.com
Subject: Connecting to queries into one
MY GOAL
To collect any consumers.id WHERE date of birth, last name
and
first name matches what was entered by the user. The trick is that
date of birth lives in
:31 AM
To: mysql@lists.mysql.com
Subject: Connecting to queries into one
MY GOAL
To collect any consumers.id WHERE date of birth, last name and first name
matches what was entered by the user. The trick is that
date of birth lives in the consumer table and last name and first
name lives in the
MY GOAL
To collect any consumers.id WHERE date of birth, last name and
first name matches what was entered by the user. The trick is that
date of birth lives in the consumer table and last name and first
name lives in the cases table (which can be joined to consumers b