Home » RDBMS Server » Server Administration » SQL Query
SQL Query [message #373667] Tue, 01 May 2001 04:37
Arcadia
Messages: 1
Registered: May 2001
Junior Member
I have a problem with an SQL quiery i'm trying to write...
This is what the batabse looks like:
Pharmacy(Name, Adress, PhoneNo)
PharmCompany(Name, PhoneNo)
Sell(PName, PCoName, TradeName, Price)

Sell.PName -> Pharmacy.Name
Sell.PCoName -> PharmComapany.Name

TradeName is the name of a drug that a pharmacy gets from a pharmacyCompany, and sells at Price.

I have to find the pharmacy that makes the most sales.

Where sales are the number of drugs that each pharmacy sells.

Note that this query must work in microsoft access.
Could anyone help?
Previous Topic: create table ...
Next Topic: How to store and retrive images and sounds in and from database
Goto Forum:
  


Current Time: Mon Dec 23 09:28:34 CST 2024