At 09:07 PM 25/01/2004 +0100, you wrote:

>There was a mistake in the first post....This is the sql I intended to
>ask about:
>
>if (exists (select 1 from TABLEONE
> where COL_IN_TABLEONE in(select COL_IN_TABLEONE from TABLE
>where (COL_IN_TABLETWO = "aValue"))
> and HISTORIE > 0 )
> ) then
>begin
>.
>.
>.
>end

if (COL_IN_TABLEONE = ANY(
SELECT COL_IN_TABLEONE FROM TABLE
WHERE COL_IN_TABLETWO = 'aValue'
AND HISTORIE > 0)) then

/hb