[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...
Subject
Written By
Posted
[NEWBIE] join query
April 15, 2008 03:00PM
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.