MySQL Forums
Forum List  »  Newbie

[NEWBIE] join query
Posted by: coke coke
Date: April 15, 2008 03:00PM

Hi all and thanks for your help!

I have two tables: users and sended mails

I would like to have the list of users have not receved a particular mail.

I made something like that

SELECT user.id from user,mail WHERE user.id != email.usrid;

But I had a wrong result (550 items! but the users are only 250...)!

Can you help me ? I'm noob...

Options: ReplyQuote


Subject
Written By
Posted
[NEWBIE] join query
April 15, 2008 03:00PM
April 15, 2008 03:14PM
April 15, 2008 03:28PM
April 16, 2008 04:49PM
April 21, 2008 03:35AM
April 15, 2008 03:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.