Home » RDBMS Server » Networking and Gateways » SQL database problem
SQL database problem [message #66680] Sat, 12 October 2002 19:28 Go to next message
marcus
Messages: 9
Registered: July 1999
Junior Member
hey,

i have a database which has customers who purchase drinks.
the entities are purchase, customer, drink and menu. for each menu, we have got one drink.

What i want to determine is the favourite drink of each customer. that is the drink most drunk by each customer is his/her favorite.
i am stuck so any help would be cool

Report message to a moderator

Re: SQL database problem [message #66703 is a reply to message #66680] Fri, 08 November 2002 05:33 Go to previous message
ibou
Messages: 2
Registered: November 2002
Junior Member
Can you send me the description of your tables,I'll write the sql instruction for you

Report message to a moderator

Previous Topic: ORA-12203 into a Stored Procedure
Next Topic: Connecting problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 02:04:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.