mOn Tue, 2003-06-03 at 09:03, Steve Meyers wrote: > 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?
The fact that I had tried it before without success. But thanks for the free flame anyway. For the record, I just tried it again: mysql> select * from machines,load_averages,logins where machines.id=logins.machine_id and machines.id=load_averages.machine_id; I must have had a syntax error before cause it works great now. I stand (sit) corrected. Woops, Dave ____________________ BYU Unix Users Group http://uug.byu.edu/ ___________________________________________________________________ List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list
