Se hai mysql >=4.1:
SELECT ID FROM A WHERE ID NOT IN (SELECT ID FROM B)
Altrimenti
SELECT A.ID FROM A LEFT JOIN B ON A.ID=B.ID WHERE B.ID IS NULL
Se hai mysql >=4.1:
SELECT ID FROM A WHERE ID NOT IN (SELECT ID FROM B)
Altrimenti
SELECT A.ID FROM A LEFT JOIN B ON A.ID=B.ID WHERE B.ID IS NULL