Help with Complex Query - Oracle Database

I have these tables in a database:

Agent(AgentPhone*, AgentName)
Constituency(ConstituencyNo*,ConstituencyName, RegionCode, ConstituencyDistrict)
Party(PartyCode*, PartyName)
PollingStation(StationNo*,ConstituencyNo*,RegionCo de, AgentPhone, StationName)
Region(RegionCode, RegionName), and
VoteResults(Party*, ResultsCategory*, Votes, AgentPhone)

* Represents the fields that form the primary keys. Results Category are L and S (representing Parliamentary and Presidential results respectively).

My question is, is it possible to write a single query to return the following:

The constituency name, its region, sum of votes of a particular category for each party? I have tried variousl combinations and cannot get a query that does this.

Finally is a sub query contains an aggregate function with an alias, how do you call that result in the calling query? For example I want to show each constituency and the votes of a particular category accruing to it and I am using the aggregate SUM(Votes) AS TotalVotes. How do I refer to this result in the calling query?

Thanks for the help. Sorry is my question is too cumbersome.

ps: I am using this within ColdFusion

Feb 29 '08 #1

Subscribe Post Reply

1201

debasisdas

8,127

Expert 4TB

Kindly post what you have tried so far.

Mar 3 '08 #2

Similar topics

"Query is too Complex"

by: Starbuck | last post by:

OK, first let me say that I am no DB person. But I have a user here who keeps getting this error whenever she does, whatever it is she does, with databases... A google search takes me to...

Microsoft SQL Server

Plz help. SQL help needed.

by: Eva | last post by:

Hi, Im new to Vb.net and am trying to create my first practice project. The problem iv encountered is to do with SQL queries issued against my Access DB iv created. i want to wright a query...

.NET Framework

query help

by: | last post by:

having a spot of trouble writing this one. if you are so inclined and have a moment, i'd really appreciate your insight. i have what amounts to a purchase order type of setup...a descriptive...

Microsoft SQL Server

Serious Query Problem for Inexperienced Access user -- Help Please

by: John Baker | last post by:

Hi: As those who have looked at this newsgroup recently will realize, I am a neophyte with Access, although I have experienced with Approach (the Lotus product). There are things I could easily...

Microsoft Access / VBA

Please can someone help me get a list of absent employees ??

by: Melissa Kay Beeline | last post by:

OK, here's the sitch : we have an access control system at work that registers ever entry/exit of every employee. I recently made some queries in Access so the ppl in HR could make reports (who...

Microsoft Access / VBA

Please help 'recordset not updateable' error

by: dd_bdlm | last post by:

Please help this one is driving me mad! I have searched and read all the topics on the error message I am receiving but none seem to apply to me! I have quite a complex query linking all parts...

Microsoft Access / VBA

merging Access query into Word document HELP

by: babyangel43 | last post by:

Hello, I have a query set up in Access. I run it monthly, changing "date of test". I would like this query to be merged with a Word document so that the cover letter is created in Word, the fields...

Microsoft Access / VBA

New to XML. Need help reading XML.

by: Justin | last post by:

Here's my XML: <?xml version="1.0" ?> <AppMode Type="Network"> <CurrentFolder Path="c:\tabs"> <Tabs> <FilePath>tabs\Justin.tab</FilePath> <FilePath>tabs\Julie.tab</FilePath> *****There could...

.NET Framework

Need Help In SQL Complex Query

by: crystal2005 | last post by:

Hi, I am having trouble with some complex SQL queries. I’ve got winestore database, taken from Web Database Application with PHP and MySQL book. And some question about queries as the following ...

MySQL Database

help with complex query, any gurus or geniuses around?

by: william67 | last post by:

I'm having a hard time building a query to do what I need to do and was hoping some genius could help me out, I need to do a complex query and any and all help is much appreciated this is the...

MySQL Database

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General