select records whose id is not present in the other table

If you are trying to select records whose ids are not present in the other table,

eg: articles table has article_id, categorized table has article_id and cat_id.
If you are trying to select the article that is not categorized yet

SELECT * FROM articles WHERE article_id NOT IN ( SELECT article_id FROM categorized );

That will solve your problem.