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 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 able to glean from the MySQL docs:
I have two tables, "data" and "archive" ... they have nearly identical columns except for "data," which contains a couple of extra columns that are not considered important once the data is moved to the "archive" table.
I need to pull data from two columns in both tables, based on the ENUM results of a third column, "favorite," in each table. To wit, if the value of column "favorite" in both "data" and "archive" = 'Y', I need to pull it for display.
$query = "SELECT id, title FROM data, archive WHERE favorite = 'Y'" doesn't cut it.
Neither does "SELECT data.id, data.title, archive.id, archive.title WHERE data.favorite = 'Y', archive.favorite = 'Y'"
Assistance, please? And can anyone recommend a good MySQL reference that's a little easier for a schlub like me to understand?
Thanks, Bob
Bob Sawyer ----------- Pixellated! Design:Develop:Deliver www.pixellated.org
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
