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]
