easy SQL that I dont understand!

Article View: bit.listserv.sqlinfo

Article #222

Back to bit.listserv.sqlinfo Previous Next

#222

From: Dan Matthews
Date: Sat, 29 Jul 2000 00:00

21 lines
1392 bytes

Hi.

I have a query which returns a league table of teams and corresponding
points, I now have a new table which details penalties incurred and i can't
figure out how to get the data from the new table into the oints totals of
the query.

The query as is reads:
==>>
SELECT v.name AS Team, SUM(r.points) AS TeamTotal
FROM VF1Team AS v, TeamPicks AS t, Driver AS d, RaceResults AS r, venue
WHERE v.id = t.teamid
AND t.driverid = d.id
AND d.id = r.driverid
AND r.venueid = venue.id
GROUP BY v.name
ORDER BY sum(r.points) DESC;
<<==

Any info, URL's (I have looked myself!) much appreciated
dan

Technical Details

Message-ID: <8ltpa4$adq$1@newsg4.svr.pol.co.uk>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 11355a,f7bbd311477dde2d,start
X-Google-Attributes: gid11355a,public
X-Google-Thread: 1131db,f7bbd311477dde2d,start
X-Google-Attributes: gid1131db,public
From: "Dan Matthews" <dan@grandprix.freeserve.co.uk>
Subject: easy SQL that I dont understand!
Date: 2000/07/29
Message-ID: <8ltpa4$adq$1@newsg4.svr.pol.co.uk>
X-Deja-AN: 652066761
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
X-Complaints-To: abuse@theplanet.net
X-Trace: newsg4.svr.pol.co.uk 964847748 10682 62.136.197.58 (29 Jul 2000 05:15:48 GMT)
Organization: Customer of Energis Squared
X-MSMail-Priority: Normal
NNTP-Posting-Date: 29 Jul 2000 05:15:48 GMT
Newsgroups: bit.listserv.sqlinfo,mailing.database.sql-general