Seriously, am not sure why I can't recall this, nor Google it.

I would like to use nested select statements in my app. In other words

Select * from table_A where userid = (Select userid from table_B where
shipped = Y)

Can someone please me out?

Many thanks ahead, as always!

On Sat, 29 Dec 2007 12:28:16 -0500, Daniel Kaplan wrote:
> Seriously, am not sure why I can't recall this, nor Google it.
>
> I would like to use nested select statements in my app. In other words
>
> Select * from table_A where userid = (Select userid from table_B where
> shipped = Y)
>
> Can someone please me out?

You'll want to google for "subquery".

--
I think I'd like to see a Simpsons episode starting up with Bart Simpson
writing "I will not attempt to undermine the Usenet Cabal".
-- J. D. Falk

Daniel Kaplan wrote:
> Seriously, am not sure why I can't recall this, nor Google it.
>
> I would like to use nested select statements in my app. In other words
>
> Select * from table_A where userid = (Select userid from table_B where
> shipped = Y)
>
> Can someone please me out?
>
> Many thanks ahead, as always!
>
>
>

In addition to Peter's comment, you need to learn about JOINs. Your
statement can easily be made into a JOIN, which does the same job more
efficiently.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Daniel Kaplan wrote:
> Seriously, am not sure why I can't recall this, nor Google it.
>
> I would like to use nested select statements in my app. In other
> words
> Select * from table_A where userid = (Select userid from table_B where
> shipped = Y)
>
> Can someone please me out?
>
> Many thanks ahead, as always!

SELECT
*
FROM table_A a
JOIN table_B b ON a.userid = b.userid and b.shipped = 'Y'

"Peter H. Coffin" <hellsop@ninehells.com> wrote in message
news:slrnfnd2lf.t2u.hellsop@abyss.ninehells.com...
> On Sat, 29 Dec 2007 12:28:16 -0500, Daniel Kaplan wrote:



> You'll want to google for "subquery".


You know, I thought I knew how to do this, but obviously I was wrong. Why
on Earth is this so hard? I really am unable to figure this out. I'm not
that old, nor that stupid, yet ever example I try from the manual online
fails.

I want to pull a userid from a select statement, and then using its returns,
select from the orders table where it matches the found userids.

I mean literaly, one of the examples lead me to try this:

select ordernum from orders where userid = (select userid from user where
email = 'xxxx');

That failed. So then I tried it this way:

select orders.ordernum from orders where orders.userid = (select user.userid
from user where email = 'xxxx');

and that failed as well.

Can someone lend me a hand please?

Signed,

Growing frustrated.

On Sun, 30 Dec 2007 11:11:34 -0500, "Daniel Kaplan"
<NoSPam@NoSpam.com> wrote:

>"Peter H. Coffin" <hellsop@ninehells.com> wrote in message
>news:slrnfnd2lf.t2u.hellsop@abyss.ninehells.com.. .
>> On Sat, 29 Dec 2007 12:28:16 -0500, Daniel Kaplan wrote:
>
>
>
>> You'll want to google for "subquery".
>
>
>You know, I thought I knew how to do this, but obviously I was wrong. Why
>on Earth is this so hard? I really am unable to figure this out. I'm not
>that old, nor that stupid, yet ever example I try from the manual online
>fails.
>
>I want to pull a userid from a select statement, and then using its returns,
>select from the orders table where it matches the found userids.
>
>I mean literaly, one of the examples lead me to try this:
>
>select ordernum from orders where userid = (select userid from user where
>email = 'xxxx');
>
>That failed.

How? Wrong results? Empty results? Error message?

>So then I tried it this way:
>
>select orders.ordernum from orders where orders.userid = (select user.userid
>from user where email = 'xxxx');
>
>and that failed as well.

How? Wrong results? Empty results? Error message?

>Can someone lend me a hand please?
>
>Signed,
>
>Growing frustrated.

Use a join.

SELECT ordernum
FROM orders
INNER JOIN user ON (userid)
WHERE user.email = 'xxxx';
(untested)
--
( Kees
)
c[_] You hear someone break into your home. You pull out your
chainsaw and crank it up. It makes its very distinctive
chainsaw noise; he hears it. What criminal is going to
stay in a house with someone that crazy?
(Home defence with Franklin Hummel r.a.sf.w) (#247)

"Daniel Kaplan" <NoSPam@NoSpam.com> wrote in message
news:1199031091.725768@nntp.acecape.com...
> "Peter H. Coffin" <hellsop@ninehells.com> wrote in message
> news:slrnfnd2lf.t2u.hellsop@abyss.ninehells.com...
>> On Sat, 29 Dec 2007 12:28:16 -0500, Daniel Kaplan wrote:
>
>
>
>> You'll want to google for "subquery".
>
>
> You know, I thought I knew how to do this, but obviously I was wrong. Why
> on Earth is this so hard? I really am unable to figure this out. I'm not
> that old, nor that stupid, yet ever example I try from the manual online
> fails.
>
> I want to pull a userid from a select statement, and then using its
> returns, select from the orders table where it matches the found userids.
>
> I mean literaly, one of the examples lead me to try this:
>
> select ordernum from orders where userid = (select userid from user where
> email = 'xxxx');
>
> That failed. So then I tried it this way:
>
> select orders.ordernum from orders where orders.userid = (select
> user.userid from user where email = 'xxxx');
>
> and that failed as well.
>
> Can someone lend me a hand please?
>
> Signed,
>
> Growing frustrated.
>
I already answered you yesterday!

"Paul Lautman" <paul.lautman@btinternet.com> wrote in message
news:5tq4cuF1etmmjU1@mid.individual.net...


> I already answered you yesterday!

I need a select within a select

"Paul Lautman" <paul.lautman@btinternet.com> wrote in message
news:5tq4cuF1etmmjU1@mid.individual.net...

> I already answered you yesterday!

Besides, your answer came up with value in ON ( ) being labeled as ambigous

"Daniel Kaplan" <NoSPam@NoSpam.com> wrote in message
news:1199040055.978242@nntp.acecape.com...
> "Paul Lautman" <paul.lautman@btinternet.com> wrote in message
> news:5tq4cuF1etmmjU1@mid.individual.net...
>
>> I already answered you yesterday!
>
> Besides, your answer came up with value in ON ( ) being labeled as
> ambigous
You do NOT need a select within a select, you need a join.

If you had entered my answer correctly, there is no way that any value in
the ON could have been labelled as ambiguous sice in my example they were
all qualified.

If you post your attempt at my answer and the corresponding error, message I
will tell you what you did wrong and you just might learn something from
your betters.

Alternatively keep being pig-headed and stew in your own juice!

"Paul Lautman" <paul.lautman@btinternet.com> wrote in message
news:5tq8p0F1enbnnU1@mid.individual.net...


> If you had entered my answer correctly, there is no way that any value in
> the ON could have been labelled as ambiguous sice in my example they were
> all qualified.
>
> If you post your attempt at my answer and the corresponding error, message
> I will tell you what you did wrong and you just might learn something from
> your betters.
>
> Alternatively keep being pig-headed and stew in your own juice!



Why should I bother?

I don't want a flame war, but people like you shouldn't post here or
elsewhere. You may know most of the answers, but your rudeness is a perfect
example of what's wrong with newsgroups and people who with e-spines.

"Daniel Kaplan" <NoSPam@NoSpam.com> wrote in message
news:1199043962.896840@nntp.acecape.com...
> "Paul Lautman" <paul.lautman@btinternet.com> wrote in message
> news:5tq8p0F1enbnnU1@mid.individual.net...
>
>
>> If you had entered my answer correctly, there is no way that any value in
>> the ON could have been labelled as ambiguous sice in my example they were
>> all qualified.
>>
>> If you post your attempt at my answer and the corresponding error,
>> message I will tell you what you did wrong and you just might learn
>> something from your betters.
>>
>> Alternatively keep being pig-headed and stew in your own juice!
>
>
>
> Why should I bother?
>
> I don't want a flame war, but people like you shouldn't post here or
> elsewhere. You may know most of the answers, but your rudeness is a
> perfect example of what's wrong with newsgroups and people who with
> e-spines.

On the contrary, it is you who chose to brush off my with extreme
rudeness and pig-headedness. If you don't want , don't bother asking for
it.

Daniel Kaplan wrote:
> "Paul Lautman" <paul.lautman@btinternet.com> wrote in message
> news:5tq8p0F1enbnnU1@mid.individual.net...
>
>
>> If you had entered my answer correctly, there is no way that any value in
>> the ON could have been labelled as ambiguous sice in my example they were
>> all qualified.
>>
>> If you post your attempt at my answer and the corresponding error, message
>> I will tell you what you did wrong and you just might learn something from
>> your betters.
>>
>> Alternatively keep being pig-headed and stew in your own juice!
>
>
>
> Why should I bother?
>
> I don't want a flame war, but people like you shouldn't post here or
> elsewhere. You may know most of the answers, but your rudeness is a perfect
> example of what's wrong with newsgroups and people who with e-spines.
>
>
>

Daniel,

Paul is one of the most knowledgeable and respected persons in this
newsgroup. He consistently volunteers significant amounts of time to
answer peoples questions.

And he did answer your question. If you would have followed his advice,
you would have your answer.

Rather, you ignored his response, criticized his code for something that
would not happpen if you had entered his code correctly. And all you
did was say it didn't work - without posting the code you actually used
and the real error message you received.

No, Paul is not at fault here.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:fradnR1fhKAPYuranZ2dnUVZ_trinZ2d@comcast.com. ..

Daniel,
>
> Paul is one of the most knowledgeable and respected persons in this
> newsgroup. He consistently volunteers significant amounts of time to
> answer peoples questions.
>
> And he did answer your question. If you would have followed his advice,
> you would have your answer.
>
> Rather, you ignored his response, criticized his code for something that
> would not happpen if you had entered his code correctly. And all you did
> was say it didn't work - without posting the code you actually used and
> the real error message you received.
>
> No, Paul is not at fault here.

Sorry Jerry, but being knowledgeable and respected doesn't give anyone the
right to start name calling. In no way does my "answering" on posts equal
his. But I can tell you that it wouldn't matter if I or he answered a dozen
questions a day. To post something like:

"Alternatively keep being pig-headed and stew in your own juice!"

is just wrong. Unless you were in a bar scene in a Chuck Norris film, you
just wouldn't normally do that in the real world face to face.

Did my confusion make my posts perfect, probably not. But in now way does
that excuse his rude response. I don't care if you're the Einsten of the
newsgroups, it doesn't give you the right to be like that. Pure and simple.

Daniel

Daniel Kaplan wrote:
> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
> news:fradnR1fhKAPYuranZ2dnUVZ_trinZ2d@comcast.com. ..
>
> Daniel,
>> Paul is one of the most knowledgeable and respected persons in this
>> newsgroup. He consistently volunteers significant amounts of time to
>> answer peoples questions.
>>
>> And he did answer your question. If you would have followed his advice,
>> you would have your answer.
>>
>> Rather, you ignored his response, criticized his code for something that
>> would not happpen if you had entered his code correctly. And all you did
>> was say it didn't work - without posting the code you actually used and
>> the real error message you received.
>>
>> No, Paul is not at fault here.
>
> Sorry Jerry, but being knowledgeable and respected doesn't give anyone the
> right to start name calling. In no way does my "answering" on posts equal
> his. But I can tell you that it wouldn't matter if I or he answered a dozen
> questions a day. To post something like:
>

And asking for doesn't mean ignoring valid responses then
complaining about things not working.

> "Alternatively keep being pig-headed and stew in your own juice!"
>
> is just wrong. Unless you were in a bar scene in a Chuck Norris film, you
> just wouldn't normally do that in the real world face to face.
>

Sorry, I agree with him. That's just how you acted.

> Did my confusion make my posts perfect, probably not. But in now way does
> that excuse his rude response. I don't care if you're the Einsten of the
> newsgroups, it doesn't give you the right to be like that. Pure and simple.
>
> Daniel
>
>
>

Because that's how you treated him. He tried to you. But you
obviously don't appreciate his attempts to .

You aren't going to win any friends in this newsgroup with your
attitude. And if you keep it up you won't get a lot of here, also.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:1c6dnen6d506iuXanZ2dnUVZ_vPinZ2d@comcast.com. ..

> And asking for doesn't mean ignoring valid responses then complaining
> about things not working.

> Sorry, I agree with him. That's just how you acted.

Don't believe I posted repsonses that way, will have to take a look back to
see if I did.

Although if I did post poor repsonses, they were in no way personal attacks
at him.

> Because that's how you treated him. He tried to you. But you
> obviously don't appreciate his attempts to .

No, I'm going to say I didn't call him names, or attack him personaly.

> You aren't going to win any friends in this newsgroup with your attitude.
> And if you keep it up you won't get a lot of here, also.

I too have been frustrated at the " me with my homework posters", the
"How do I do this with no details" posters, etc. But before I post back an
angry response I try and remember that that this another human being behind
the other side of the screen. And I at least try not to make my posts
non-personal, and definitely without the name calling.

I'm sorry that you can't see that that is what I am talking about here. So
I'll just give you the same advice I gave him. If you want to stay on this
poor offshoot topic of the thread, then simply don't read my posts.

I know at this point, I would actually prefer not to waste my time on this
part of the thread anymore.

Thanks.


>
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@attglobal.net
> ==================
>

Daniel Kaplan wrote:
> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
> news:1c6dnen6d506iuXanZ2dnUVZ_vPinZ2d@comcast.com. ..
>
>> And asking for doesn't mean ignoring valid responses then complaining
>> about things not working.
>
>> Sorry, I agree with him. That's just how you acted.
>
> Don't believe I posted repsonses that way, will have to take a look back to
> see if I did.
>
> Although if I did post poor repsonses, they were in no way personal attacks
> at him.
>
>> Because that's how you treated him. He tried to you. But you
>> obviously don't appreciate his attempts to .
>
> No, I'm going to say I didn't call him names, or attack him personaly.
>
>> You aren't going to win any friends in this newsgroup with your attitude.
>> And if you keep it up you won't get a lot of here, also.
>
> I too have been frustrated at the " me with my homework posters", the
> "How do I do this with no details" posters, etc. But before I post back an
> angry response I try and remember that that this another human being behind
> the other side of the screen. And I at least try not to make my posts
> non-personal, and definitely without the name calling.
>
> I'm sorry that you can't see that that is what I am talking about here. So
> I'll just give you the same advice I gave him. If you want to stay on this
> poor offshoot topic of the thread, then simply don't read my posts.
>
> I know at this point, I would actually prefer not to waste my time on this
> part of the thread anymore.
>
> Thanks.
>
>
And I know I prefer not to waste my time with you, either. My response
would have been exactly the same as Paul's. And I don't need your
attitude, either.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:cfOdnZJjboYFvuXanZ2dnUVZ_t_inZ2d@comcast.com. ..

> And I know I prefer not to waste my time with you, either. My response
> would have been exactly the same as Paul's. And I don't need your
> attitude, either.

I gave you none, none at all. Geez.

Daniel Kaplan wrote:
> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
> news:cfOdnZJjboYFvuXanZ2dnUVZ_t_inZ2d@comcast.com. ..
>
>> And I know I prefer not to waste my time with you, either. My response
>> would have been exactly the same as Paul's. And I don't need your
>> attitude, either.
>
> I gave you none, none at all. Geez.
>
>
>
>

Nope, but your attitude shows in your posts to Paul.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message

> Nope, but your attitude shows in your posts to Paul.

I'm going to have to disagree. The worse attitude that might show in my
posts is someone who isn't posting proper details. Perrhaps because of
frustration, whether that's valid or not, but that's about it.

His "pig-headed" (and your "I would too") response is just uncalled for.
Sorry, but that's the way it is. Most people 6 foot 2 and 250 lbs wouldn't
talk that way to a total stranger that way face to face for no reason.

I'm trying to point out that talking that way, even on just a newsgroup, is
rude, uncalled for, and on a totally different level.

So please Jerry, chances are that neither you nor him would ever say...Yeah,
that "pig-headed" response was too far. So have the decency to at least
stop with the "oh that was totally called for" posts.

Have a good new year

"Daniel Kaplan" <NoSPam@NoSpam.com> wrote in message
news:1198949293.695097@nntp.acecape.com...

For those finding this thread looking for the same answer, it appears that
what I was trying:

select orderid from bOrders where userid IN (select userid from email =
'John@abc.com');

should have worked all along. But posting somewhere else I saw that someone
mentioned the version of MySQL. Turns out you need to be running at least
version 4.1 or higher of MySQL. I am not. So either figure out the whole
join thing, or upgrade your MySQL. I'm going to try and get my datacenter
to upgrade it.

*** please not that this is not tested yet.

And for those who were just following this thread from the side, yeah, sorry
for the whole thing.

Thanks as always

On Dec 31, 6:26 am, "Daniel Kaplan" <NoS...@NoSpam.com> wrote:
> "Daniel Kaplan" <NoS...@NoSpam.com> wrote in message
>
> news:1198949293.695097@nntp.acecape.com...
>
> For those finding this thread looking for the same answer, it appears that
> what I was trying:
>
> select orderid from bOrders where userid IN (select userid from email =
> 'J...@abc.com');
>
> should have worked all along. But posting somewhere else I saw that someone
> mentioned the version of MySQL. Turns out you need to be running at least
> version 4.1 or higher of MySQL. I am not. So either figure out the whole
> join thing, or upgrade your MySQL. I'm going to try and get my datacenter
> to upgrade it.
>
> *** please not that this is not tested yet.
>
> And for those who were just following this thread from the side, yeah, sorry
> for the whole thing.
>
> Thanks as always

or just use a JOIN

Daniel Kaplan wrote:
> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
>
>> Nope, but your attitude shows in your posts to Paul.
>
> I'm going to have to disagree. The worse attitude that might show in my
> posts is someone who isn't posting proper details. Perrhaps because of
> frustration, whether that's valid or not, but that's about it.
>

Yea, guys like you never want to admit they're wrong.

> His "pig-headed" (and your "I would too") response is just uncalled for.
> Sorry, but that's the way it is. Most people 6 foot 2 and 250 lbs wouldn't
> talk that way to a total stranger that way face to face for no reason.
>

Yep, it's always someone else's problem. Never yours.

> I'm trying to point out that talking that way, even on just a newsgroup, is
> rude, uncalled for, and on a totally different level.
>

So is ignoring responses, not providing accurate or complete information
and just being an arsehole.

> So please Jerry, chances are that neither you nor him would ever say...Yeah,
> that "pig-headed" response was too far. So have the decency to at least
> stop with the "oh that was totally called for" posts.
>

You really should just own up to the fact you screwed up and got called
on it, instead of trying to blame everything on Paul.

You don't want responses like this? Post complete and accurate
information - including code you tried. Read the responses and make use
of their suggestions.

If something doesn't work, check to see that you entered it correctly.
And if you still can't find the problem, post complete and accurate
details of what you did - including the code you actually used.

You didn't do this. And Paul called you on it. If you don't like it,
that's tough. But if you continue with similar behavior here, you will
get similar responses - from many of the regulars.

Of course, you can pay a consultant to you. Then you don't need to
put up with those kinds of responses in this newsgroup.

> Have a good new year
>
>
>


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

"strawberry" <zac.carey@gmail.com> wrote in message
news:77bdc9de-0ff3-476a-ac55-

>>>>> or just use a JOIN

That sounds familiar... Actually in all seriousness, for me I find the
alertanitive to be far more legible, easier to type, etc.

p.s. So yeah, it's also tested and works now. Whew....

On 2007-12-31, Daniel Kaplan <NoSPam@NoSpam.com> wrote:
> His "pig-headed" (and your "I would too") response is just uncalled for.

Saying that you are acting pigheaded (which is different from saying
you are pigheaded) may be less than 100 percent fully polite, but your
complaints about it indicate you have rather thin skin.

If you had spent the same effort into posting details about your
problem as you do complaining about how you were treated your problem
would be solved.