On Wed, Feb 16, 2000 at 10:32:09PM -0600, Douglas Bates wrote:
>but for 'Able' and 'Charlie' I keep coming up with an empty set
>
>mysql> select a.* from articles as a, authors as w1, authors as w2
> -> where a.seq = w1.seq and w1.seq = w2.seq and w1.name like 'Able'
> -> and w2.seq like 'Charlie';
>Empty set (0.01 sec)
>
>I hope I am missing something obvious and you can enlighten me.
I'm afraid you will kick yourself very hard. The last line above says
"w2.seq like 'Charlie'". I think you can figure out what is wrong with
that little snippet, after looking at the values of authors.seq. :)
Tim
--
Tim Smith < tim@stripped > :MySQL Development Team: Boone, NC USA.
