Rutger’s Weblog

Dit selecteert records uit messages die geen gerelateerde records hebben in mailbox.

SELECT
      m.postid,
      m.boxid
FROM
      messages a AS m
LEFT JOIN mailbox AS b ON (m.boxid = b.boxid)
WHERE b.boxid IS NULL

This entry was posted on Wednesday, July 12th, 2006 at 10:05 am and is filed under Algemeen. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.