SenatorSID Name Year Service Party CID1 Jerry 5 Rep 22 Mary 2 Dem 33 Barry 12 Dem 1CountyCID Name Democrats Republicans1 Evergreen 75,000 70,0002 Marsh 12,000 25,0003 Hilltop 9,500 8,000A) List each county in alphabetical order with the senator that serves the county

gurudevi
Profile Answers by gurudevi Questions by gurudevi
Nov 15th, 2007
6
1845

Questions by gurudevi answers by gurudevi

Showing Answers 1 - 6 of 6 Answers

rajakumar_na
Profile Answers by rajakumar_na

Nov 22nd, 2007

Try this,

SELECT c.name county, s.name senator
FROM county c, senator s
WHERE s.cid = c.cid
ORDERY BY county;

Result;

COUNTY               SENATOR
-------------------- --------------------
Evergreen              Barry
Hilltop                    Marry
Marsh                   Jerry

anugrah17
Profile Answers by anugrah17

Jan 9th, 2008

above solution is also correct, but a join is always better :)
--------------------------------------------------------------------------

SELECT     Country.Name AS Country, Senator.Name AS Senator
FROM         Country INNER JOIN
                      Senator ON Country.CID = Senator.CID
ORDER BY Country.Name