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)



Previous Visitor Comments

Name Email Subject Location
Mikaeli8wp46d1s_at_outlook.cometpBXtBmjNlJFKEF
The Ships’s Voyages I feel technological know-how just ceasus it to be even worse. Now there is a channel to never ever care, now there wouldn’t be considered a likelihood for them to find .

Maeckyjh168hotel_at_hotmail.comaPMgqFsnutzqeYzPSY
This is way more hlefpul than anything else I’ve looked at.

Juann Straussmavusi_at_gmail.comRE: Klein versoekie
Nou toe nou. Daar ler ek nog iets. Nou kan ek twee sekondes minder spandeer aan SQL scripts.

Jaco Straussfeedback_at_strauss.za.com@Juann Strauss
Juann, 'n INNER JOIN word geimpliseer as mens SQL in hierdie formaat skryf. Vir 'n LEFT JOIN moet dit spesifiek gespesifiseer word. Ek verkies hierdie formaat aangesien mens dadelik met oogopslag kan sien of dit 'n INNER of OUTER join is...

Juann Straussmavusi_at_gmail.comKlein versoekie
Hi, ek dink dis baie snaaks, maar wil jy nie asseblief INNER JOIN's tussen die "table names" insit nie?

BrianAnonymousHAHAHAHA
I love it!!!

dandan_at_themani agree
spot on brother!

Shakabwkste001@gsb.uct.ac.zaSQL
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!
Very nice!! I like it!

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

Roryrory@onlinedebt.co.zaYour sql
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