(ungetestet)[sql]SELECT * FROM B WHERE B.B_ID NOT IN (SELECT B_ID FROM B JOIN A ON A.ID = B.ida);[/sql]