SELECT *
FROM   `a`
WHERE  NOT EXISTS
(SELECT *
FROM   `b`
WHERE  `b`.`id` = `a`.`id`)