Tag Archives: irishblogs

MySQL: Finding the records in one table that are not in another table

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?

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

: 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

Close

Ad-blocker not detected

Consider installing a browser extension that blocks ads and other malicious scripts in your browser to protect your privacy and security. Here are a few options.

  • uBlock Origin is a free, open source, ad blocker for your browser.
  • Use pi-hole if you have a spare Raspberry Pi on your network.
  • Set the private DNS settings on your phone to dns.adguard.com to block adverts and trackers.