OraFAQ Forum: SQL & PL/SQL » Complex Report

Home » SQL & PL/SQL » SQL & PL/SQL » Complex Report

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

Complex Report [message #37364]

Fri, 01 February 2002 21:27

Hem
Messages: 2
Registered: February 2002

Junior Member

Hi I have created two tables...
Movies(MovieNo*, Title,YrMade)
Videos(VideoNo*,MovieNo,TimesRented, DueDate)

I want report as follows:

Movie Hire Summary Report for 2001
-----------------------------------

Movies --- Total

ABCD --- xxx
EFGH --- xx

Here total is Video.TimesRented There can be more than 1 video of a given movie. So I have to calculate all the video.TimesRented of a given movie in Videos table and then output as a report.

Need urgent help. WUd be appreciable

THanking you,
HEM

Report message to a moderator

Re: Complex Report [message #37366 is a reply to message #37364]

Sat, 02 February 2002 06:03

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

select videos.movieno,sum(video.timesrented) "Total"
from movies,videos
where movies.movieno=videos.movieno
group by videos.movieno

Report message to a moderator

Previous Topic:	sql function
Next Topic:	Can i have multiple tablespaces for one oracle dataspace?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 12:42:38 CDT 2024