Yeah! Thanks all for your help, I found another script that allowed it
to work using first one select, then looping through the values and
putting those in another select.
-warner
On Thursday, October 31, 2002, at 08:59 AM, Vincent Greene wrote:
I think it may depend on the version of MySql, b
Well, I was curious to see...looks like mySQL hasn't implemented
sub-selects every as yet. Bummer. But, they show the LEFT JOIN
alternative as Vincent has already pointed out. :-)
http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html
Excerpt:
MySQL Server currently only supports nested queries
I think it may depend on the version of MySql, but in the version I am
using, sub-selects are not supported. You can get the same results with a
left join like:
select email from Member left join PollVote on Member.pk_member_id =
PollVote.member_id
where PollVote.member is null
I suspect once yo
I will try. See Ollie> belowthis isn't tested on anything...just off
the top of my head.
At 08:07 AM 10/31/2002 -0700, you wrote:
Hi all,
My SQL skills are apparently a bit rusty (been a while since I've had to
do any hard SQL ;-) and I would appreciate any help with this.
I am working on
> > all members who have not voted.
> > Member
> > pk_member_id
> > email
> > PollVote
> > member_id
> > poll_id
> select email from Member, PollVote where Member.pk_member_id !=
> PollVote.member_id and PollVote.poll_id = 4
I'm not a great SQL dude either..but I think this sub-
Oops, goofed up my example sql a little, changes below:
On Thursday, October 31, 2002, at 08:07 AM, Warner Onstine wrote:
Hi all,
My SQL skills are apparently a bit rusty (been a while since I've had
to do any hard SQL ;-) and I would appreciate any help with this.
I am working on my polling s