| phpninja 2006-02-28, 8:28 pm |
| ------ =_Part_9576_14852792
.1141065365217
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Why do some many people that work in the U.S government post to this mysql
list? Do they really hire people with no experience ? I fear for our
homeland..
-----Original Message-----
From: Courtney Braafhart
& #91;*mailto:courtney
.braafhart@vr.ne.gov*<courtney.braafhart@vr.ne.gov>]
Sent: Monday, February 27, 2006 10: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 cases table (which can be joined to consumers by
consumers.id and cases.consumer_id).
Can anyone think of way to do this in one mysql statement instead of doing =
a
loop?
I am thinking it would work something like this:
SELECT consumers.id FROM consumers WHERE date_of_birth =3D ? AND
consumer.id =3D (SELECT consumer_id FROM cases WHERE last_name =3D ?
AND full_first_name =3D ? )
Is there a way to form the above statement in MYSQL?
MY HOPE
That there is a really obvious solution to this question and that I am
simply suffering from a case of the Mondays!
Thanks in advance!
Courtney Braafhart
--
MySQL General Mailing List
For list archives: *http://lists.mysql.com/mysql*<http://lists.mysql.com/my=
sql>
To unsubscribe: *http://lists.mysql.com/mysql? unsub...a
il.com*
------ =_Part_9576_14852792
.1141065365217--
|