sorry, probably should have mentioned that all the tables are empty atm

mark

--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...> wrote:
>
> My guess is that you have some "contacts" records without a parent
> record in the customer table. What does this query return?
>
> select *
> from contacts
> where customerid not in
> (select id from customer);
>
> You are allowed to have more than one table with a foreign key to the
> same parent field, so that won't be it.
>
>
> Adam