| Help Needed [message #317250] |
Wed, 30 April 2008 04:42  |
sibgat
Messages: 42
Registered: November 2006
Location: Chennai |
Member |
 
|
|
Hi,
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
Regards
Sibgat
Attachment: sql.JPG
(Size: 164.14KB, Downloaded 15 time(s))
|
|
|
| Re: Help Needed [message #317260 is a reply to message #317250 ] |
Wed, 30 April 2008 05:03  |
Michel Cadot
Messages: 15238
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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).
Regards
Michel
|
|
|
| Re: Help Needed [message #317312 is a reply to message #317260 ] |
Wed, 30 April 2008 07:56 |
rleishman
Messages: 2563
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
|
|
|
]
Members
Search
Help
Register
Login
Home
