I'm building a planning system for a newspaper. Article ideas are defined as articles with no deadline, no publication date or no reporter assigned. I wan't to show all entries from table un_article that matches those three criterias.
I have three tables:
CREATE TABLE un_article
a_id INT PRIMARY KEY AUTO_INCREMENT,
a_deadline DATE DEFAULT "0000-00-00",
a_issue DATE DEFAULT "0000-00-00",
a_ready ENUM("Y","N") DEFAULT "N",
a_picture ENUM("N","B","G","R","F") DEFAULT "N",
CREATE TABLE un_section
s_id INT PRIMARY KEY AUTO_INCREMENT,
CREATE TABLE un_article_writer
a_id INT NOT NULL,
u_id INT NOT NULL,
PRIMARY KEY (a_id, u_id)
I want to get un_article.a_id, un_article.a_header and un_section.s_name for the entries in un_article for which un_section.s_id = un_article.a_section, un_article.a_deadline = '0000-00-00' and un_article.a_issue = '0000-00-00' and also only for entries in un_article whose un_article.a_id doesn't match a un_article_writer.a_id.
But I'm not able to build this query. I have tried various variants of the following, without any success.
"SELECT un_article.a_id, un_article.a_header, un_section.s_name FROM un_article, un_section, un_article_writer WHERE un_article.a_id != un_article_writer.a_id AND un_section.s_id = un_article.a_section AND un_article.a_deadline = '0000-00-00' AND un_article.a_issue = '0000-00-00' ORDER BY un_section.s_name ASC, un_article.a_header ASC"