Code: Select all
mysql_query("select title, page_content.page_id FROM page_content, menu WHERE page_content.page_id != menu.page_id GROUP BY page_id")Moderator: General Moderators
Code: Select all
mysql_query("select title, page_content.page_id FROM page_content, menu WHERE page_content.page_id != menu.page_id GROUP BY page_id")Code: Select all
SELECT title, page_id FROM page_content WHERE NOT EXISTS(SELECT page_id FROM menu WHERE menu.page_id = page_content.page_id) GROUP BY page_id