OraFAQ Forum: SQL & PL/SQL » About the query...

Home » SQL & PL/SQL » SQL & PL/SQL » About the query...

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

About the query... [message #289676]

Tue, 25 December 2007 04:31

ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh

Member

dear friends..
I have two tables like...
table1
ID NAme
01 aaaa
02 bbbb
03 cccc

table2
id name address
02 bbb Comilla
05 ddd dhaka
06 asas Ctg

I want to see the table1 id and name who are not in table2
like----

id name
01 aaaa
03 cccc

thanks

Report message to a moderator

Re: About the query... [message #289679 is a reply to message #289676]

Tue, 25 December 2007 05:03

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

NOT EXISTS
This is a newbie question.
Generally speaking, given your knowledge, post your question in newbie forum, we'll move it to expert one if it is needed.

Regards
Michel

Report message to a moderator

Re: About the query... [message #289692 is a reply to message #289679]

Tue, 25 December 2007 08:49

cgmsuresh
Messages: 29
Registered: December 2007
Location: http://maps.google.com/ma...

Junior Member

Use MINUS - SET OPERATOR.

select id,name from table1
MINUS
select id,name from table2

Gotcha!!!

Report message to a moderator

Re: About the query... [message #289796 is a reply to message #289676]

Wed, 26 December 2007 02:53

spmano1983
Messages: 269
Registered: September 2007

Senior Member

Hi,

Try this and get back.

select * from table1 where (id,name) not in (select id,name from table2);

Mano

Report message to a moderator

Previous Topic:	Problem in doing group by in query
Next Topic:	Unable to extend temp segment on tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 10 13:43:12 CST 2025