Thanks Gary and thanks lbass. Both replies were helpful. lbass, I used the second option in your reply and it worked awesome. Thanks again for the help.
Here is a query I write in SQL*Plus that gives me exactly what I need in a report I am creating:
select l.messaging_id,l.name,l2.name,p.pager_id,
o.START_DATE, o.END_DATE, o.REMARK,
from listing l, listing l2, on_call_assignment o,
pager_assignment p
where l.MESSAGING_ID =...
That's exactly what I needed. Thanks for taking the time to respond so quickly. I try to figure things out on my own before disturbing the masses. I am a Oracle Database guy that has been thrown into creating Crystal Reports and Crystal is a little like learning a new language :( Thanks for...
Hey guys,
I am a newbie to this site and hope someone can point me in the right direction. I am creating a report that requires the output to report on any changes made to a system for the current date between the times of 8:00 AM and 3:30 PM. I am trying to use a function that will...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.