Hi,

now it works.

Best Regards
Bernhard

----- Original Message -----
From: "Svein Erling Tysvær" <svein.erling.tysvaer@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, July 27, 2001 11:47 AM
Subject: Re: [ib-support] another Error


> Don't know the answer to your question, but try
> SELECT DISTINCT SCHICHT FROM DATEN
> WHERE NOT EXISTS(SELECT 1 FROM SCHICHT WHERE SCHICHT.SCHICHTID =
> DATEN.SCHICHT)
> to find which values of SCHICHT exist in DATEN that is not in your SCHICHT
> table.
>