Re: Problem with Retrieving Data from Two Tables
Date: Tue, 22 Jan 2002 10:06:59 +0100
Message-ID: <1011689644.957740_at_news.thyssen.com>
Hi HOque,
(would be better to user your real name),
maybe you want something like this:
SELECT ue.*
Hth,
"Leader" <sohelcsc_at_yahoo.com> schrieb im Newsbeitrag
news:b1a93c73.0201212347.71a4b084_at_posting.google.com...
FROM table1 ue, table2
WHERE ue.user_id = table2.user_id(+)
AND table2.user_id IS NULL;
Guido
> HI All,
> I am facing a problem what i am describing below.
>
> Suppose I have one table TAble1 where the fields are user_ID, email.
> and i have another table Table2 where the fiels are also user_ID , email.
> Table2's User ID is foreign key from Table1.
> Now i want the User_ID and Email from Table1 which are not exist in
Table2.
> I have one sql statement which uses NOT IN.
> select ue.user_ID, ue.email
> from Table1 ue
> where ue.User_ID NOT IN
> (select User_ID
> from Table2) order by user_ID
>
>
> but i don't want to use it. I want
> any other statement without NOT IN. Can anyone help me please?
>
> Thanks
> HOque
Received on Tue Jan 22 2002 - 10:06:59 CET