Home » SQL & PL/SQL » SQL & PL/SQL » Two tables join query.
Two tables join query. [message #238772] Sat, 19 May 2007 23:03 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Dear friends,

I have two tables :

DEPT:

deptno

10
20
30
40


and

EMP:

empno deptno

1 10
2 10
3 20
4 20
5 30
6 30
7 40
8 40


i expecting the output below:

empno deptno
1 10
2
3 20
4
5 30
6
7 40
8

Any body help me..

Arun..















[Updated on: Sun, 20 May 2007 02:16]

Report message to a moderator

Re: Two tables join query. [message #238775 is a reply to message #238772] Sat, 19 May 2007 23:11 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
Please read & follow the #1 Sticky post at the top of this forum
>i expecting below output:
How/why do you expect the purported output?
Re: Two tables join query. [message #238787 is a reply to message #238772] Sun, 20 May 2007 00:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

How to format your posts

BREAK

Regards
Michel
Re: Two tables join query. [message #238966 is a reply to message #238787] Mon, 21 May 2007 01:33 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
http://www.orafaq.com/forum/fa/596/0/
Arun,
you are really testing the moderators' patience here.


http://www.orafaq.com/forum/fa/448/0/

Closed.

MHE
Previous Topic: sql query shows matched but not ummatched records
Next Topic: Indexing
Goto Forum:
  


Current Time: Sat Dec 03 18:17:02 CST 2016

Total time taken to generate the page: 0.16135 seconds