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
SELECT consumers.id FROM consumers, cases
WHERE
consumers.id=cases.consumers_id
AND consumers.date_of_birth = ?
AND cases.last_name = ?
AND cases.first_name = ?
John A. McCaskey
-Original Message-
From: Courtney Braafhart [mailto:[EMAIL PROTECTED]
Sent: Monday, February 27, 2006 10:
select consumers.id from consumers LEFT JOIN cases ON consumers.id =
cases.id WHERE consumers.date_of_birth = '?' AND cases.last_name = '?' AND
cases.full_first_name = '?'
-Original Message-
From: Courtney Braafhart [mailto:[EMAIL PROTECTED]
Sent: Monday, February 27, 2006 1:31 PM
To: mys
