I have a user who is using the following query to try and delete rows from one table based on the lack of a user id in another table:
SELECT s.questionid, s.userid, s.questionanswer FROM Users u, SurveyAnswers s WHERE u.id != s.userid The corresponding user rows have already be deleted from the table Users. Thus, this of course seems to match on just about everything since there is no actualy record in the Users table to match on. Is there some way to match on a lack of information? Thanks, Jonathan Duncan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
