is the user id still there? if not, an outer join should be what you need to
use to get all the rows where there is no match in the other table
bastien
From: Merlin <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] selecting rows with no reference
Date: Wed, 08 Dec 2004 12:30:34 +0100
H
This is probably what you are looking for:
SELECT m.subject,m.status,u.user_id
FROM messages m
LEFT JOIN user u ON m.sender_user_id=u.user_id
WHERE u.user_id IS NULL
That will give you all message without a related user.
On Dec 8, 2004, at 6:30 AM, Merlin wrote:
Hi there,
I know this is a question