JOIN function in SELECT

2003-03-31 Thread Bob Sawyer
First, a little rant: I don't know what it is about the MySQL docs that make them so difficult for me to read, but try as I may, I have the most difficult time making heads or tails of anything in the official MySQL documentation. That being said, here's my question, the answer to which I was NOT

Re: JOIN function in SELECT

2003-03-31 Thread gerald_clark
This is not really a MySQL docs problem. The manual gives the mysql syntax, but you are expected to already know SQL. You need to get a book on SQL. SELECT data.id, data.title FROM data,archive WHERE data.favorite=archive.favorite AND data.favorite='Y'; Bob Sawyer wrote: First, a little rant: I

RE: JOIN function in SELECT

2003-03-31 Thread Bob Sawyer
: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 12:46 PM To: [EMAIL PROTECTED] Cc: MySQL List Subject: Re: JOIN function in SELECT This is not really a MySQL docs problem. The manual gives the mysql syntax, but you are expected to already know SQL. You need to get a book