SQl problem

Article View: borland.public.vdbase.data.sql

Article #456

Back to borland.public.vdbase.data.sql Previous Next

#456

From: J�rund Seim
Date: Sat, 21 Nov 1998 00:00

22 lines
1217 bytes

I have a table with the following fields:
ShopName, RatingService, RatingWorkshop, AuthorName

The idea is that an author can post a rating for the shops Service and
Workshop. Therefore, the shopname will be present several times in the
table. The ratings can be a value of 1, 2 or 3, indicating poor, fair or
good service level.

To repsent the results, I would like to make a querywith the follwoing
fields:

ShopName, RatingPoor, Rating Fair, Rating Good

The shop name should be present only once. The RatingPoor, RatingFair and
RatingGood fields should count the number for eachop, and present it in the
�corresponding field.  Is this possible, or do I have to redesign my table?

Any help would be appreciated.

Joerund Seim
Copenhagen, Denmark
origo@earthling.net

Technical Details

Message-ID: <3656c40a.0@news.euroconnect.dk>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: ff5a1,a3e0c07e9f0014a8,start
X-Google-Attributes: gidff5a1,public
From: "J�rund Seim" <origo@earthling.net>
Subject: SQl problem
Date: 1998/11/21
Message-ID: <3656c40a.0@news.euroconnect.dk>
X-Deja-AN: 414194193
X-Trace: 21 Nov 1998 13:45:46 GMT, 195.184.50.2
Newsgroups: borland.public.vdbase.data.sql
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3