Re: [PHP-DB] Selection an id from a table where it doesn't exisit in another

2001-08-29 Thread Dobromir Velev
lt;[EMAIL PROTECTED]> Date: Thursday, August 30, 2001 4:17 AM Subject: [PHP-DB] Selection an id from a table where it doesn't exisit in another >Hi Guys, > >I have two tables, words and searchwords. words contains a list of words >with an id number next to them and searchwords co

[PHP-DB] Selection an id from a table where it doesn't exisit in another

2001-08-29 Thread Scott Mebberson
Hi Guys, I have two tables, words and searchwords. words contains a list of words with an id number next to them and searchwords contains a page id with a word id (from the words table). I want to select all of the id's from the words table which does not exist in the word_id feild in the searchw