I know this is a question for the mysql mailing list, but maybe one of you guys also could help out with that.
I do have to tables (users, messages). Now there unfortunatelly are some messages where the sender in the user table is missing.
I am trying to find all messages which do not have the belonging user anymore.
So I tried this: SELECT m.subject, m.status FROM user u, messages m WHERE m.sender_user_id != u.user_id
But this returns far to many rows.
Has anybody an idea how to do that?
Thank you in advance,
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php