NOT IN statement or what to use in this case?
DELETE FROM fps WHERE fps.id NOT IN
    (SELECT DISTINCT fps_id FROM fmmp)


The sub query should find a list of fps ids that are being referred to, so you can delete any fps entries that are not in that list.