| 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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
