Home » SQL & PL/SQL » SQL & PL/SQL » Help Needed (ORACLE 9i)
Help Needed [message #317250] Wed, 30 April 2008 04:42 Go to next message
Messages: 45
Registered: November 2006
Location: Chennai

In the attached image, the circled area shows that FORD has applied for Leaves (GL,PL) in the same date range,
i want to know any logic, where in i can have the output in a single line
for example, rather than GL and PL in different line, i want them to be in one line like GL,PL, with rest of the common columns,
Thanks for your time

  • Attachment: sql.JPG
    (Size: 164.14KB, Downloaded 79 times)
Re: Help Needed [message #317260 is a reply to message #317250] Wed, 30 April 2008 05:03 Go to previous messageGo to next message
Michel Cadot
Messages: 63917
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is NOT an expert question.

It is clearly stated in the forum description: "Newbies should not post to this forum!"
Expert notion is defined in the sticky: Not an EXPERT? Post in the NEWBIES forum, NOT here
Rules are described in: OraFAQ Forum Guide
Read them, follow them including what is said about formatting.

As you are an expert, I don't answer the question because you obviously already knows it.

Also, don't be so lazy and post the query not an image (that I am too lazy to download).

Re: Help Needed [message #317312 is a reply to message #317260] Wed, 30 April 2008 07:56 Go to previous message
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Try a self-join. Join the table to itself to find records with the same name and overlapping dates.

Ross Leishman
Previous Topic: Correct way of usingCursor
Next Topic: Insert Trigger
Goto Forum:

Current Time: Mon Oct 24 15:46:14 CDT 2016

Total time taken to generate the page: 0.14992 seconds