OK, this’ll make users of “proper databases” cringe but because MySQL doesn’t support sub-selects you can’t do the most obvious way of selecting records in one table that aren’t in another. Here’s how it’s done, with a clear explanation of why it works!
select po.id
from po left join pn
on po.id=pn.id
where pn.id is null
Unfortunately, I can’t figure out how to filter the second table as I don’t want to select from the whole table, only a subset. Anyone solved this?
Tag Archives: irishblogs
Top 25 Censored Stories
These stories have been doing the rounds but I haven’t read them yet. Oh my!
#1: Wealth Inequality in 21st Century Threatens Economy and Democracy
#2: Ashcroft vs. the Human Rights Law that Holds Corporations Accountable
#3: Bush Administration Censors Science
#4: High Levels of Uranium Found in Troops and Civilians
#5: The Wholesale Giveaway of Our Natural Resources
#6: The Sale of Electoral Politics
#7: Conservative Organization Drives Judicial Appointments
#8: Cheney’s Energy Task Force and The Energy Policy
#9: Widow Brings RICO Case Against U.S. government for 9/11
#10: New Nuke Plants: Taxpayers Support, Industry Profits
Grip – ripping CDs
When using Grip to rip your CDs make sure to click the “Config->Misc->Do not lowercase filenames” box. Otherwise you get lame filenames.
Pics
Hurricane Frances Approaches Florida
I would not like to be in Florida right now! *gulp*
Kitten Looking For a Home
This very, very cute kitten is looking for a home. He was born without eyes but in the right home…
Thanks Sharon for finding this!
Edit: domain is gone. bah.
On Being a Photographer – Bill Jay
In this interview, Bill Jay gives his thoughts on photography. It rambles a little but he makes some good points.
Bridge Under Construction, part 2
Take a step back from the bridge and there’s an alleyway leading up towards Shandon and the north side of the city.
U.S. Military Clears A-Team Of Charges
This is great news! Finally they can join society and make use of their “make-anything-with-a-few-pipes-and-corrogated-iron” skills in legit industry!
Woohoo! We're rich!
So, my boss has a Million Dollar Bill on his desk and I wondered what we could buy with it..
<donncha> woohoo! we're rich! my boss has a $1,000,000 note on his desk!
<donncha> and he's gone to Chicago for a few days.. hmm, what to buy? *grin*
* minus1 drops around to make a few photocopies
<kevin> donncha: so that's much higher then a c note?
<minus1> kevin: i make it about 12 octaves
<donncha> sigh
<kevin> donncha: if you guys b sharp around him, maybe he'll buy a flat for each of you.
* donncha holds his head in his hands and cries.
<minus1> G, kevin, i H it when you get like this [the note A is called H in some countries]
<kverens> minus1, jsb once wrote his name into a tune using A as the H in BACH
<kevin> minus1: i should just pitch the rest, huh?
<kverens> tone it down a bit maybe
<kevin> well, at this point i'm sure donncha is tuning us out.
<pron> the volume of puns is overwhelming
<minus1> pron: wait till we treble it!
<kverens> almost cacophonic, pron
<minus1> all your bass are belong to us.
<pron> minus1: that's fishing !
<kverens> well, a musical fish is the tuna
<pron> kverens: you can tune a piano, but you can't tuna fish
<minus1> kverens: shall we sing a psalmon ?
<kverens> you'll have to school me in it
<pron> minus1: your singing is atroutious
<kverens> pike down there
<minus1> pron: it's all about sole...
<kverens> and knowing the coda
* Fawkes is fed up of herring these puns...
<Fawkes> surely you could go some plaice else
<kverens> w'eel think about it
* Fawkes hopes to see a ray of hope on this soon
<pron> kelly ?
<Fawkes> as the sky continues whitening
<kverens> you're codding yourself
<Fawkes> i'm not feeling that well....
<Fawkes> and you have to make sick jokes like that
<pron> oh ? someone you ate ?
<Fawkes> surely you're asprin to better puns?
<minus1> Fawkes: naw, he's too busy codeine
<minus1> I WISH TO REGISTER A COMPLAINT!
<Fawkes> yes Sir? what about?
<kverens> Fawkes, you're past your eyes in bad puns now
<minus1> kverens: will you stop milking it!
<pron> moo
<kverens> dairy continue?
<minus1> if you do, you'll lack toes soon
<minus1> i dare say you're lack-toes intolerant.
<pron> OOhh .. .*that was painful
* Fawkes deosn't think anyone is cow'd by that threat....
<kverens> I don't knead to be buttered up with threats
<Fawkes> oh just cheese it folks
<minus1> cud you get any worse?
<Fawkes> i'd brie very grate-ful
<pron> kverens: you're a tough old cookie then ?
<minus1> Fawkes: actually, something oc-curd to me
<elrond> Those who've have had too much of it can join me in #punlesslinux
It continued, but I’m not going to subject you to the rest of it!