There are probably many ways but try:

Select * from parent where parent_id not in (select parent _id from child)

Does this do what you want?

>Hi to all
>I have 2 tables in a relation on one field. I would now want to select records in the parent table where there are no corresponding records in the child table.
>
>Any easy way to do this?
>
>Thanks in advance.
>
>Willie