Issues Africa World Philosophy Afrikaans Leisure General

Selecting worthwhile ANC, NNP politicians...

Great tool for Electoral Colleges

Jaco Strauss
11 November 2003 E-Mail this page to a friend

If you had a database of all the politicians in the world, which query would you run? I would've been tempted to try the following one, although the outcome would've been pretty obvious....
SELECT p.Name,
       p.Surname
FROM Party pp,
      Country c,
      Politician p,
      Characteristic ch,
      PoliticianCharacteristic pc
WHERE c.CountryID = p.CountryID
      and pp.PartyID = p.PartyID
      and ch.CharacteristicID = pc.CharacteristicID
      and p.PoliticianID = pc.PoliticianID
      and c.CountryName = 'South Africa'
      and pp.PartyName in ('ANC', 'NNP')
      and ch.Characteristic not in ('Corrupt',
             'Oppertunist',
             'Spineless',
             'Useless',
             'Clueless')
ORDER BY p.Surname;

Resultset

Name              Surname
----------------- ---------------------

(0 row(s) affected)

Last 25 Visitor Comments
Name Email Subject Date
BrianAnonymousHAHAHAHA1/21/2006
I love it!!!

dandan_at_themani agree11/7/2005
spot on brother!

Shakabwkste001@gsb.uct.ac.zaSQL2/26/2004
Great code. Keep me posted with these. When you have a chance, go out there and fight the real battle for RSA. Your stuck in the past buddy. (Also use spellcheck - you don't seem to be dong too well in that area)

Brianbrianmaike@hotmail.comThats a good one!1/8/2004
Very nice!! I like it!

Mr & Mrs Wragglordwragg@ananzi.co.zaSql11/22/2003
Well done... But I think thats how they get chosen in the first place.

Roryrory@onlinedebt.co.zaYour sql 11/20/2003
Excellent, Jaco...you could really go to town on this!

P L E A S E   P A R T I C I P A T E
No active contact accepted
Name
E-mail Address
Subject
Comment


Previous Article If Architects had to work like Programmers
Next Article Pizza Inversion - a Pattern for Efficiency

HOME Top Back Print E-Mail Page E-Mail us Guestbook