Ken,
Don't you want ...
...
INNER JOIN table_2 as b ...
...
PB
-----
> I'm having some real problems figuring out a seemingly simple join
> statement. I've looked through some of the mailing list posts, but I
can't
> seem to find what I'm looking for. Here's what I have - 2 tables:
>
> table1 (id, stimulus_number, stimulus_type)
> table 2 (id, stimulus_number, stimulus_type)
>
> Basically, all I want to do is to determine how many matches there are,
> where the stimulus_number & stimulus_type are the same in both tables,
based
> on a certain id. Here's a verbose example:
>
> table 1: contains 2 entries for id=2
> --> stimulus_number=23, stimulus_type='word'
> --> stimulus_number=34, stimulus_type='image'
>
> table 2: contains 2 entries for id=2
> --> stimulus_number=23, stimulus_type='word'
> --> stimulus_number=34, stimulus_type='word'
>
> The desired result, should display the following:
> --> 23, word
> ... since that was the only entry that was common to both tables, for id=2
> ... note, both stimulus_number & stimulus_type have to match in both
tables
> (not just one or the other).
>
> Here's what I've tried:
> --> select distinct a.stimulus_number, a.stimlus_type
> from table_1 as a
> left join table_2 as b
> on a.stimulus_type=b.stimulus_type
> and a.stimulus_number=b.stimulus_number
> where id=2;
>
> ... this looked ok to me, but it spits out any results that have common
> stimulus_numbers, OR common stimulus_types.
>
> Any help would be greatly appreciated,
>
> Thanks in advance,
>
> Ken
>
> (sql)
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
