On Tue, 2003-06-03 at 08:50, David Smith wrote:
> Here is another example of something that MySQL can't do that you may
> want to do:
>
> SELECT * FROM users, articles, comments WHERE users.id =
> articles.user_id AND users.id = comments.user_id
Huh? The only reason MySQL chokes on this one is that you didn't
specify tables in your *. It will do this just fine:
SELECT users.*, articles.*, comments.* FROM users, articles,
comments WHERE users.id = articles.user_id AND users.id =
comments.user_id
What in the world made you think MySQL couldn't handle a simple join?
Steve
____________________
BYU Unix Users Group
http://uug.byu.edu/
___________________________________________________________________
List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list
