RE: "JOIN" function in SELECT

2003-03-31 Thread Bob Sawyer
nal Message- > From: 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 synta

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 d